What are sub-queries? Give example? In which case
sub-queries are not feasible?
- 4 Answers
- 10629 Views
- Infosys, I also Faced
- E-Mail Answers
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
Why do we use trigger?
What is the difference between online clustering and Offline clustering?
Can a database be shrunk with users active?
What is Transparent Data Encryption?
What is primary key, unique key, and foreign key?
What is use of except clause? How does it differ from not in clause?
Can I delete event logs?
What is cdc in sql server?
Explain table valued parameters in sql server? Why tvp used?
What are distinctive joins find as a part of sql?
What is difference between commit and rollback when used in transactions?
What is trigger explain with program?
What is use of dbcc commands?
What is used to replicate sessions between instances in coldfusion clusters?
List types of tables in SQL Azure?
