What is the dual table in SQL?

[Team AHT]

The dual table is a temporary table which contains exactly one column whose name is dummy and a single row.

In SQL Server, the equivalent of the “dual” table in Oracle is a system table called “sys.dual”. This table contains a single row and a single column, and is often used in SQL queries to perform calculations or return a single result without needing to select from an actual table. You can use it in a similar way to the “dual” table in Oracle.

 

[Author]

Posts