Interested to Buy Any Domain ? << Click Here >> for more details...
Can we rewrite subqueries into simple select statements or
with joins? Example?
- 2 Answers
- 9287 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
Other than truncate statement, which other command can by-pass the trigger on the tables?
wat wil hapn if we give the both read and deny read permission to user?
How to identify current user in ssrs report?
Can we call stored procedure in trigger?
how can you check the level of fragmentation on a table? : Sql server administration
What is measure group, measure? : sql server analysis services, ssas
What is transaction server implicit?
What is meant by referential integrity?
what are cursors? : Sql server database administration
Explain the properties of sub-query in sql server?
What are statistics?
What are types of subqueries?
Why do you need a sql server?
How many categories of functions based their return modes?
Which table keeps information about stored procedures?
