What are sub-queries? Give example? In which case
sub-queries are not feasible?
Answer Posted / bernatshaw
Sub-query means a Query within a Query.
This is the Example:
Select Employee_Id, Employee_name From Employees Where
Employee_Id IN (Select Mgr_Id from Manager)
Is This Answer Correct ? | 12 Yes | 2 No |
Post New Answer View All Answers
Explain about unique identifier data type in sql server?
what stored procedure can you use to display the current processes? : Sql server administration
What is the difference between createstatement and preparedstatement?
what are the types of indexes? : Sql server database administration
What is the difference between varchar and varchar types?
What are the operating modes in which database mirroring runs?
What is the security principal at the server level that represents your session?
What are the steps to process a single select statement?
How we create SQL Server 2005 Reporting Services ? Give me Sample
How to generate random numbers with the rand() function in ms sql server?
What are the tool windows in sql server management studio? : sql server management studio
What are user-defined functions (udfs) in sql server?
How to transfer data from a cursor to variables with a "fetch" statement?
Do you know spatial data types - geometry and geography in sql server 2008?
What to check if a User database is locked?