SQL Dialects Reference/Select queries/Select without tables

From Wikibooks, the open-content textbooks collection

Jump to: navigation, search

[edit] Select without tables

  • DB2
VALUES

or

SELECT expressions FROM sysibm.sysdummy1
  • Firebird / InterBase
SELECT expressions FROM rdb$database
  • Ingres, MySQL, MSSQL, SQLite, Linter
SELECT expressions
  • Oracle
SELECT expressions FROM dual
  • PostgreSQL
VALUES (expression)

or

SELECT expressions
Retrieved from "http://en.wikibooks.org/wiki/SQL_Dialects_Reference/Select_queries/Select_without_tables"