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
1237648721220599866307454270284785664273519573045225.076-1.9071182.39828147.8478nnngn
123767464992846644131976412735657779228451943315197.167-1.6694942.55322757.61084nnngn
1237674603753963554342334621570066432304516092225326.392-1.8973672.84792134.52435nnngn
1237674648855838762363742937697249280323516152815372.768-1.6304222.83503637.0514nnngn
1237671940870438953891811996620580864792523533615383.696-1.5266822.90818632.1334nnngn
123765718983435881212239128964010086401087529302175437.149-1.9772082.8357832.48497nnngn
123766371655542378912769351905847808001134526445995482.42-1.8553082.12319136.35374nnnnn
123766354422248250512803071233554124801137529715785180.803-1.6347822.388864.05825nnngn
123765690634443175212869401962222981121143526191335012.11-1.8406892.13829666.12368nnngn
12376487201325716701293670313338365952114953003415442.593-1.990262.43050631.85057nnnnn

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