Interested to Buy Any Domain ? << Click Here >> for more details...
CTE(common table expression)
- 1 Answers
- 9024 Views
- Thomson Reuters, I also Faced
- E-Mail Answers
A common table expression (CTE) is a temporary result set
that is defined within the execution scope of a single
SELECT, INSERT, UPDATE, DELETE, or CREATE VIEW statement. A
CTE is similar to a derived table in that it is not stored
as an object and lasts only for the duration of the query.
Unlike a derived table, a CTE can be self-referencing and
can be referenced multiple times in the same query.
A CTE can be used to:
1. Create a recursive query.
2. Substitute for a view when the general use of a view is
not required; that is, you do not have to store the
definition in metadata.
3. Reference the resulting table multiple times in the same
statement.
4. Enable grouping by a column that is derived from a scalar
subselect, or a function that is either not deterministic or
has external access.
| Is This Answer Correct ? | 9 Yes | 0 No |
Can we take the full database backup in log shipping?
What is sub query and its properties?
What is page in sql server?
Find first and last day of current month in sql server
What is INTVAL( )and where we use Plz any body help me
what are the Prerequisites for Replication?
Explain the xml support sql server extends?
Does an index slow down updates on indexed columns?
Explain mixed authentication mode of sql server?
what command is used to create a table by copying the structure of another table?
What is the security model used in sql server 2005?
How many categories of functions based their return modes?
-
Oracle (3259) - SQL Server (4518)
- MS Access (429)
- MySQL (1402)
- Postgre (483)
- Sybase (267)
- DB Architecture (141)
- DB Administration (291)
- DB Development (113)
- SQL PLSQL (3330)
- MongoDB (502)
- IBM Informix (50)
- Neo4j (82)
- InfluxDB (0)
- Apache CouchDB (44)
- Firebird (5)
- Database Management (1411)
- Databases AllOther (288)
