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
12376623029787689261890395342269081600167953149345300.54-1.6258542.78641934.23573nnngn
1237660959177637984233962088772623462420785337835492.982-1.9024012.0718361.33567nnnnn
12376609591776381702339622811871583232207853378105349.698-1.8429132.05302155.42847nnngn
12376603444594610192339634906499488768207853378545208.292-1.5673822.3608763.79614nnngn
123766034445893652823396764130634373122078533782055193.039-1.7508942.29522447.82536nnngn
123766034445991953923397921366622607362078533786265390.931-1.750872.9599948.76324nnngn
123766557145274807024579453839558840322183535363855287.997-1.9281142.53066434.60437nnngn
123766622910624570724579404361535590402183535363675446.627-1.7840352.92218437.75251nnngn
123766620924352951924579060764151910402183535362425377.262-1.5597942.96256146.5129nnngn
123766622803302830524578824369151938562183535361565033.867-1.8037672.0906241.85569nnnnn

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