Answer / deepak_shr

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 mysql the same as sql server?

0 Answers  

---

What is user defined datatypes and when you should go for them?

0 Answers  

---

Write an SQL query to obtain the 2nd highest salary.

0 Answers   Akamai Technologies,

---

How will you optimize a stored procedure optimization?

0 Answers  

---

Which are the new data types introduced in sql server 2008?

0 Answers  

---

which database is best to use in oracle and sql server? explain reasons?

5 Answers   TCS,

---

What command would you use to create an index?

0 Answers  

---

find the 3rd max salary

10 Answers  

---

where the connection string store in the database

0 Answers   HCL, Wipro,

---

Why and when do stored procedure recompile?

0 Answers  

---

What is a result set object returned by mssql_query()?

0 Answers  

---

How to access the inserted record of an event?

0 Answers  

---