Raymond
Select from dual in T-SQL / SQL Server
insights Stats
warning Please login first to view stats information.
toc Table of contents
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.
In SQL Server, you can directly select values without specifying a table name.
Code snippet
SELECT "Constant Value" AS COLUMN_NAME;
info Last modified by Raymond 5 years ago
copyright
This page is subject to Site terms.
comment Comments
No comments yet.