What are sub-queries? Give example? In which case
sub-queries are not feasible?
Answer Posted / rajendra
Sub query mean query within query ,but when you use sub
query on larg amount data that time it is not feasible
| Is This Answer Correct ? | 4 Yes | 3 No |
Post New Answer View All Answers
1.how to find the dead lock in sql server? 2.How to fine the memory leaks in sql server? 3.suppose transaction log file increasing what action will take ?
Differentiate between a having clause and a where clause.
What is sql profiler. What are the default templates with it? : sql server database administration
How can I create a report based on a query? : sql server management studio
How to retrieve error messages using mssql_get_last_message()?
What is cursor in ms sql server?
How to enable tcp/ip protocol on a sql server?
Mention the different types of replication in sql server.
What is sql server 2000 work load governor?
1 01 101 01010
What is the difference between nvl and nvl2?
What is the maximum rows in sql server table?
How many types of stored procedures are there in sql server?
What is the purpose of sql profiler in sql server? : sql server database administration
Is BCNF better than 2NF & 3NF? Why?