Your SQL command was:
 SELECT top 10 so.bestobjid, so.specobjid, so.plate, so.mjd, so.fiberid,
 sp.teffadop, sp.fehadop, sp.loggadop, sp.snr, sp.flag 
 FROM specobjall so
 JOIN sppparams sp ON so.specobjid = sp.specobjid and so.sciencePrimary=1
 WHERE sp.teffadop > 4500 and sp.teffadop < 5500
 and fehadop > -2 and fehadop < -1.5
 and loggadop > 2 and loggadop < 3
 and sp.flag like '_n%'
 and sp.snr > 30

Your query output (max 500,000 rows):

bestobjidspecobjidplatemjdfiberidteffadopfehadoploggadopsnrflag
123765547182247130524478359240427182082174535214715256.201-1.5713182.68266348.46709nnngn
123765547182247151024478383979438807042174535214805359.256-1.5768562.67246539.2668nnngn
123765547182247123824478587389089945602174535215545240.685-1.640792.36539753.98549nnngn
123765547182247121924478603881764362242174535215605441.453-1.5095292.89407530.17394nnngn
123765537303835457024478612128101570562174535215635280.502-1.7654532.66238243.98692nnngn
123766621139120978424579890895430881282183535365445462.372-1.9460912.97901947.09299nnngn
123766622856970293224579747958919270402183535364925435.488-1.7272592.81255841.9136nnngn
123766621192768759624579613268744867842183535364435366.009-1.8992732.82710457.30849nnngn
123766557145294451924579583032175104002183535364325276.87-1.5899582.38137437.05894nnBgn
123766622803270101424579580283396034562183535364315238.569-1.6421472.66587832.53284nnngn

Use the button below to upload the results of the above query to the SAS and from there click Search to download or view the spectra:

Upload list of spectra to SAS