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
123765550456910662924556853376036638722181535243555172.133-1.8023672.34928733.68387nnnGn
123765550403249787424556803898013388802181535243375259.597-1.7310412.54875747.9981nnngn
123765495266967557624556765415106416642181535243235380.345-1.5439412.90380446.8857nnngn
123766247531020306524546369715369676802180546136375330.464-1.6520092.74745157.9864nnngn
123766230084105039324545940905834844162180546134815130.706-1.5740572.28949356.769nnngn
123766230084085366824545748491299983362180546134115118.51-1.5597822.27825764.17852nnngn
123766146545719722324545710008393011202180546133975036.588-1.9197822.11747.36873nnngn
123766146545713173724545567071881400322180546133455309.253-1.8551262.39641740.74408nnngn
123766233679822858924545440628044206082180546132995104.882-1.5444492.00285969.57405nnngn
12376653293257359442389166544362956800212254178255296.409-1.9799822.49278632.89374nnngn

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