What are sub-queries? Give example? In which case
sub-queries are not feasible?
Answer Posted / amit kumar
A subquery is simply a SELECT query within a SELECT query.
example:-
SELECT City, Salary, (SELECT AVG(Salary) FROM Employee)
AS AvgSalary FROM Employee;
Is This Answer Correct ? | 1 Yes | 4 No |
Post New Answer View All Answers
Which are ddl commands?
What is an indice?
What are the advantages to use stored procedures?
Introduction of rollup clause using sum and group by clause?
What is shrink log file?
What is partition index in sql server?
The external application that is executed in one of the tasks does not have a log file, but only a screen log. How can I save the data from the screen? : sql server management studio
What is an entity-relationship diagram (erd)?
What keyword you will use to get schema appended to the result set of a ‘for xml’ query?
Explain about local stored procedure?
What is a covering index?
Explain difference between cross join and full outer join?
How to execute a sql statement using odbc_exec()?
What is function of ROLLUP ?
What is change data capture (cdc) feature?