Can we rewrite subqueries into simple select statements or
with joins? Example?
- 2 Answers
- 8025 Views
- ASD Lab, I also Faced
- E-Mail Answers
Answer Posted / syed sajjad
Yes we can write using Common Table Expression (CTE). A Common Table Expression (CTE) is an expression that can be thought of as a temporary result set which is defined within the execution of a single SQL 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.
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
what types of replication are supported in sql server? : Sql server database administration
How will you know when statistics on a table are obsolete?
What are the new features in SQL Server 2005 when compared to SQL Server 2000?
Can anyone tell that the extra features are there in SQL SERVER 2008 that are not available in previous versions .
What is resultset concur_updatable?
Determine when an index is appropriate?
Explain Reporting Life Cycle?
What is ms sql server index?
How to replace null values in expressions using isnull()?
What is the standby server?
Which are the olap features?
How to identify current user in ssrs report?
What is the difference between for xml raw and for xml auto?
What are the types of user defined functions in sql server?
How sql server enhances scalability of the database system?
