access_time 3y languageEnglish
more_vert

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
thumb_up 0
comment Comments
No comments yet.