SELECT from nothing?

December 17, 2022 by Tarik

It’s not consistent across vendors – Oracle, MySQL, and DB2 support dual:

SELECT 'Hello world'
  FROM DUAL

…while SQL Server, PostgreSQL, and SQLite don’t require the FROM DUAL:

SELECT 'Hello world'

MySQL does support both ways.