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
123765294691772011521527621836944445441912532931515385.604-1.6481092.83483434.28706nnngn
12376603444594610192339634906499488768207853378545208.292-1.5673822.3608763.79614nnngn
123765932603100385024478202560020224002174535214145441.873-1.6181912.89991130.84626nnnnn
123765547182240580924478213555136501762174535214185313.708-1.5365832.3921847.07042nnngn
123765550350159067324568395563270410242182539054585200.123-1.6592292.47707838.60139nnngn
123765513038449908624568398312049479682182539054595226.48-1.8518172.4235340.68005nnngn
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