sdss 查询示例

示例1:

SELECT specObjID, z from SpecObjAll

WHERE specObjID = 448110941716899840

 

 

示例2：

SELECT b.specObjID, b.z, b.cModelAbsMag_g
from stellarMassFSPSGranWideDust as b , mydb.liu_ra_dec_z_210129 as c
WHERE b.ra < c.ra + 0.1 and b.ra > c.ra - 0.1 and b.dec < c.dec + 0.1 and b.dec >c.dec - 0.1