What are sub-queries? Give example? In which case
sub-queries are not feasible?
- 4 Answers
- 10301 Views
- Infosys, I also Faced
- E-Mail Answers
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
Why SQL Agent is used?
How to convert a unicode strings to non-unicode strings?
What is the difference between deallocate cursor and close cursor?
What are the disadvantages of using the stored procedures?
What are the system database in sql server 2008?
What are the two modes of authentication in sql server?
Does sql server use java?
What is the maximum size of column in sql server?
What is an sql server agent?
What is sql server english query?
What are trace files?
Explain the etl (extraction, transformation, and loading)?
What is scan table/view and seek table/view when its occurs? : sql server database administration
What is a with(nolock)?
Can I use sql azure as a backup with log shipping or database mirroring?
