access_time 3 years ago languageEnglish
more_vert

Select from dual in T-SQL / SQL Server

visibility 86 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 3 years ago
thumb_up 0

comment Comments

No comments yet.

Follow Kontext

Get our latest updates on LinkedIn.

Want to contribute on Kontext to help others?

Learn more