Answer Posted / swapna
Subquery is used to get information from a table based on
unknown conditions.
If select stmt not perform entire task using
selection,projection,and joins then we can perform that
type of task using sub queries.
| Is This Answer Correct ? | 3 Yes | 8 No |
Post New Answer View All Answers
Explain user defined views?
Define cursor locking
Explain table valued parameters in sql server? Why tvp used?
What is the purpose of indexing?
how do you determine the Load performance of any query in sql server {example how do u determine performance of a select stmnt which returns Dynamically many no of records ... some times 100,1000,10000 etc., }
What options are available to audit login activity? : sql server security
Why are sql functions used?
What to check if a User database is locked?
What is Service Broker in sql server 2012?
What is a document index?
How to bind a view to the schema of the underlying tables?
what's the difference between a primary key and a unique key? : Sql server database administration
What is dknf in normalization form?
Why would you use sql agent?
can an order by clause be used in a creation of a view?