Interested to Buy Any Domain ? << Click Here >> for more details...
What is a CTE (Common Table Expression), and how is it different from a subquery?
- 3 Answers
- 1381 Views
- I also Faced
- E-Mail Answers
Answer Posted / hr@tgksolutions.com
• CTE: Temporary result set defined using WITH and reusable within the query. Improves readability for complex queries.
• Subquery: Nested query executed each time it is called. Example:
WITH SalesCTE AS (
SELECT employee_id, SUM(sales) AS total_sales
FROM sales
GROUP BY employee_id
)
SELECT * FROM SalesCTE WHERE total_sales > 5000;
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
If i can use sys.check_constraints to display my constraints from my database using sql server 2005, how can i display then if i am using sql server 2000????
Why do we use cursors?
Will truncate release space?
How many primary keys can a table have?
How bulk collect improves performance?
Is sql a case sensitive language?
What is rowtype?
What is denormalization in a database?
Is sql a dbms?
What is a parameter query?
how would concatenate strings in mysql? : Sql dba
Is record in oracle pl sql?
what is the difference between ereg_replace() and eregi_replace()? : Sql dba
Can variables be used in sql statements?
What does pl sql stand for?
