mssql t-sql

Select from dual in T-SQL / SQL Server

event 2019-11-18 thumb_up 0 visibility 1,302 comment 0 insights

more_vert

warning Please login first to view stats information.

Code snippets and tips for various programming languages/frameworks. All code examples are under MIT or Apache 2.0 license unless specified otherwise.

Code snippet

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 6 years ago copyright This page is subject to Site terms.

Select from dual in T-SQL / SQL Server

insights Stats

Code snippet

Log in with external accounts

Select from dual in T-SQL / SQL Server

insights Stats

Table of contents

Code snippet

Log in with external accounts