SQL Dialects Reference/Select queries/Select without tables

From Wikibooks, open books for an open world
Jump to: navigation, search

Select without tables[edit]

Sometimes one needs to execute SQL scalar expressions without table context, i.e. make a query that would act as normal SELECT operator, evaluate given comma-separated expressions and return a table with single row and one or multiple columns (one for every individual expression). Obviously, expressions can't reference any columns from the tables, as there are none.

An example is determining the value of a mathematical function, using Oracle syntax:

SQL> select 4*atan(1) as "Arc tangent of 1 times 4" from dual;

Arc tangent of 1 times 4
Standard  ?
  • SELECT expressions FROM sysibm.sysdummy1
Firebird SELECT expressions FROM rdb$database
Ingres SELECT expressions
Linter SELECT expressions
MonetDB SELECT expressions
MSSQL SELECT expressions
  • SELECT expressions
  • SELECT expressions FROM dual
Oracle SELECT expressions FROM dual
SQLite SELECT expressions
Virtuoso  ?