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
as a part of your job, what are the dbcc commands that you commonly use for database maintenance? : Sql server database administration
What is attribute relationships, why we need it? : sql server analysis services, ssas
What are the steps you will take to improve the performance of a poor performing query?
Explain about Normalization?
Benefits of Stored Procedures?
What is SQL Azure Firewall?
What does the on delete cascade option do?
What is tabulation?
Mention what are the different types of ssrs reports?
Explain what is log shipping?
IF more than one Site is accessing the same Database server and I want to move the DB with Minimum down time? How will you do
How to loop through result set objects using odbc_fetch_row()?
What is report server project?
What are the different types of backups avaialabe in sql server 2005?
Where sql server user names and passwords are stored in sql server? : sql server database administration