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
123766622803270101424579580283396034562183535364315238.569-1.6421472.66587832.53284nnngn
123766557145294451924579583032175104002183535364325276.87-1.5899582.38137437.05894nnBgn
123766557145274807024579453839558840322183535363855287.997-1.9281142.53066434.60437nnngn
123766622910624570724579404361535590402183535363675446.627-1.7840352.92218437.75251nnngn
123766620924352951924579060764151910402183535362425377.262-1.5597942.96256146.5129nnngn
123766622803302830524578824369151938562183535361565033.867-1.8037672.0906241.85569nnnnn
12376662269594828862457853574734964736218353536515050.208-1.7270432.07473540.76466nnngn
12376662103178609872457845053519849472218353536205416.024-1.896272.7371132.26343nnnnn
12376662274964853852457843679130314752218353536155248.245-1.6980822.24349446.02505nnngn

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