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
1237650371559292943377266387422308352335520003275349.272-1.8222582.691432.61974nnngn
1237651252580122659684694512831850496608520815365416.688-1.6095022.06841130.67893nnngn
1237652598491447335720635625794988032640522002175349.126-1.6210052.77313430.36547nnngn
12376582984589639821123717972154673152998527502544696.641-1.9574972.56676932.66964nnngn
12376635426076754111159695919512315904103052914695394.878-1.6962462.91380938.23197nnngn
123765718983435881212239128964010086401087529302175437.149-1.9772082.8357832.48497nnngn
123766717239073180512261545254469242881089529131805257.993-1.6033692.45521533.16129nnngn
123766354422248250512803071233554124801137529715785180.803-1.6347822.388864.05825nnngn
123765690634443175212869401962222981121143526191335012.11-1.8406892.13829666.12368nnngn
123766378313279079816900621345803735041501537403145202.792-1.9236432.39979248.03032nnngn

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