SDSS Query Results

Your SQL command was:

SELECT TOP 10 p.objid, p.ra, p.dec, ISNULL(s.specobjid,0) AS specobjid, ISNULL(s.z, 0) AS z 
FROM Galaxy AS p
LEFT OUTER JOIN SpecObj s ON s.bestObjID = p.objID 
WHERE 
p.u BETWEEN 0 AND 19.6 AND p.g BETWEEN 0 AND 20

Your query output (max 500,000 rows):

objid	ra	dec	specobjid	z
1237651758284997753	270.013518211282	-0.0012224292956174	0	0
1237651758284998226	270.055302911682	0.0504866958910645	0	0
1237651758284997995	270.035223193071	0.0879587143021003	0	0
1237651758284932353	269.959045681551	0.0936062852649651	0	0
1237651758284997361	269.992781540926	0.105030455307205	0	0
1237651758284998234	270.067948855277	0.0874770928895343	0	0
1237651758284931153	269.882198900415	0.0209650873337183	0	0
1237651758284997600	270.063543362895	0.106184863029589	0	0
1237659089256514399	270.027505056505	-0.128753322140722	0	0
1237651758284931202	269.872432349192	0.046180752777641	0	0

Your SQL command was: SELECT TOP 10 p.objid, p.ra, p.dec, ISNULL(s.specobjid,0) AS specobjid, ISNULL(s.z, 0) AS z FROM Galaxy AS p LEFT OUTER JOIN SpecObj s ON s.bestObjID = p.objID WHERE p.u BETWEEN 0 AND 19.6 AND p.g BETWEEN 0 AND 20

Your query output (max 500,000 rows):

Your SQL command was:
SELECT TOP 10 p.objid, p.ra, p.dec, ISNULL(s.specobjid,0) AS specobjid, ISNULL(s.z, 0) AS z FROM Galaxy AS p LEFT OUTER JOIN SpecObj s ON s.bestObjID = p.objID WHERE p.u BETWEEN 0 AND 19.6 AND p.g BETWEEN 0 AND 20