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
How to get the definition of a user defined function back?
What is the difference between a function and a trigger?
How to convert numeric values to integers in ms sql server?
How to create nested stored procedure?
What are security principals used in sql server 2005?
How to assign new column names in a view?
What are the types of subscriptions in SQL Server replication?
Explain microsoft sql server functions?
What is normalization of database? What are its benefits?
What is the difference between char, varchar and nvarchar?
What is 1nf 2nf?
Can we join two tables without primary key?
On a windows server 2003 active – passive failover cluster, how do you find the node which is active?
What is recursion? Is it possible for a stored procedure to call itself or recursive stored procedure? How many levels of sp nesting are possible?
Why are you getting errors when creating a new odbc dsn?