LAMOST ADQL example queries

If you have any question, please email to support(at)china-vo.org

Query LAMOST LRS Catalogue TOP 10

    SELECT TOP 10 * FROM "public".catalogue ORDER BY obsid

Query LAMOST LRS Catalogue with position constraint

    SELECT TOP 10 obsid, ra, dec
    FROM "public".catalogue
    WHERE CONTAINS(POINT('ICRS', ra, dec), CIRCLE('ICRS', 332.202274, -2.056767, 0.00028))=1

Query LAMOST LRS Catalogue by obsid

    SELECT TOP 10 c.obsid, c.ra, c.dec
    FROM "public".catalogue AS c
    WHERE c.obsid < 101100