- This topic has 0 replies, 1 voice, and was last updated 10 months, 3 weeks ago by .
Viewing 1 post (of 1 total)
Viewing 1 post (of 1 total)
- You must be logged in to reply to this topic.
Home › Forums › SQL Discussion › SQL Window Functions › What is the dual table in SQL?
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.