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
What are the new features introduced in SQL Server 2000 (or the latest release of SQL Server at the time of your interview)? What changed between the previous version of SQL Server and the current version?
What is difference between joins and subqueries?
Why truncate is ddl command?
You want to use bids to deploy a report to a different server than the one you chose in the report wizard. How can you change the server url?
What stored procedure would you use to view lock information?
User wants only to display only pdf as export option in report manager. How to achieve this?
What are the purpose of Normalisation?
Explain the xml support sql server extends?
What is indexing explain it with an example?
Write the syntax for stuff function in an sql server?
What are rows and columns?
What is a primary index?
Do you know what are the ways available in sql server to execute sql statements?
If a stored procedure is taking a table data type, how it looks?
How to Update from select query in sql server?