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
What is the purpose of object explorer and its features? : sql server management studio
Difference between DELETE and TRUNCATE?
how to create “alternate row colour”?
How do I create a trace in sql server?
What are the mathematical functions supported by sql server 2005?
what's the information that can be stored inside a bit column? : Sql server database administration
Explain four layers of abstraction microsoft architectured?
What are the types of lock supported by ?
How you can change the database name in SQL SERVER?
What is relationship? What number of sorts of relationship are there?
What is set nocount on?
What are the different Topologies in which Replication can be configured?
Explain about Views?
What do you mean by an execution plan? Why is it used?
What is normalization and its types?