Interested to Buy Any Domain ? << Click Here >> for more details...
What are sub-queries? Give example? In which case
sub-queries are not feasible?
- 4 Answers
- 11748 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
How many categories of functions based their return modes?
What is the difference between the application object and session object?
What is a DBMS, query, SQL?
What is database black box testing?
In what three ways is the return statement used in a stored procedure?
What is create command?
Can we insert data if clustered index is disabled?
Write an SQL query to obtain the 2nd highest salary.
Explain the categories of stored procedure i.e. System stored procedure, local stored procedure, temporary stored procedure, extended stored procedure, remote stored procedure?
Can sql server 2016 run on windows 7?
Which operator do you use to return all of the rows from one query except rows are returned in a second query?
as a general practice, it is recommended to have dbo be the owner of all database objects however, in your database you find number of tables owned by a user other than dbo, how could you fix this? : Sql server administration
how to trace the traffic hitting a sql server? : Sql server database administration
What types of Joins are possible with Sql Server?
What is the log shipping?
