access_time 3y languageEnglish
Select from dual in SQL / Hive
visibility 1,545 comment 0
In Oracle database, you can select from dual table if you only want to return a one row result set. In many other databases, the query engine supports select directly from constant values without specifying a table name.
info Last modified by Raymond 3y
No comments yet.