• » Instruments
• » Products List
• - Asteroid Catalog
• » Pointing Data Archives
• » Catalog Archives (CAS)
• - Update Information
• - Search Tools
• · Radial Search
• · Rectangular Search
• · Object Cross-ID
• · Match-up with SIMBAD/NED
• · SQL Search
• · Download Client-side Tools
• - Visual Tools
• · Explore
• · Image List
• - Database Documents
• · SQL Schema
• · Tables
• · Views
• · Functions
• - Help
• · SQL Tutorial
• · SQL General Reference
• · FAQ
• · Query Limits
• · Web API
• » Data Archives (DAS)
• » Links
• » JUDO

SQL Search

You can directly submit a SQL (Structured Query Language) query to the `AKARI CAS' of DARTS database server.

If you think that using SQL calls is difficult, see also our Tutorial page or SDSS SQL Tutorial page .

-- Basic of SELECT statement of SQL: -- - SELECT col1 [as c1], col2 [as c2], ... -- Set required columns after SELECT keyword. -- You can define aliases after `as' keyword. -- - FROM table1 [t1], table2 [t2], ... -- Set table or view names after FROM keyword. -- t1 and t2 are aliases of each table. -- - WHERE conditions... -- Set conditions after WHERE keyword. -- -- This is an example query to obtain the first 10 -- rows of FIS catalog using a flux cut. SELECT objID, objName, ra, dec, fDeg2LonStr(ra) as ra_hms, fDeg2LatStr(dec) as dec_dms, fQual_65, fQual_90, fQual_140, fQual_160, flux_65, flux_90, flux_140, flux_160 FROM FisObjALL WHERE 19.5 < flux_90 AND flux_90 <= 20.0 LIMIT 10

Database: DR1 (Fis:V1 Irc:V1)			Check Syntax Only?
Format: HTML TEXT delimiter: newline:LFCR+LFCR

You can select version of FIS and IRC catalogs by Database selector. Default setting is for latest version of catalog set.

See the SQL schema page (Tables, Views, Functions) to find out more about structure or function of the SQL.