Interested to Buy Any Domain ? << Click Here >> for more details...
CTE(common table expression)
- 1 Answers
- 9019 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 |
What is cursors?
What are all new concepts in SQL Server 2008? That is Exactly Difference between 2005 to 2008
Why de-normalization required?
Why functions are used in sql server?
What are the different types of subquery?
How to add more data to the testing table in ms sql server?
Can we create SP inside SP ? If no Y ? If yes Y ? Explain with an example ?
How to list all user defined functions in the current database?
What is named calculation? : sql server analysis services, ssas
Name the different type of indexes in sql?
What is the purpose of sql profiler in sql server? : sql server database administration
Explain the stored procedure?
-
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)
