What are sub-queries? Give example? In which case
sub-queries are not feasible?
- 4 Answers
- 10300 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
Can the query output be sorted by multiple columns in ms sql server?
How to create a login account in ms sql server to access the database engine using "create login" statements?
can SSRS reports Cache results?
What is mscorsvw.exe - process - microsoft .net framework ngen?
How global temporary tables are represented and its scope?
How to write an inner join with the where clause in ms sql server?
What is the Main Difference between ACCESS and SQL SERVER?
Can a table be created inside a trigger?
Explain what are the different index configurations a table can have?
What is the use of tempdb? What values does it hold?
What is @@error in sql?
What is stretch database in sql server?
What are the mathematical functions supported by sql server 2005?
What happens if null values are involved in arithmetic operations?
how to do partition in sqlserver
