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
- 12142 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
Is it safe to delete log files?
What are dml triggers and types of dml triggers?
What is table-valued sub query?
List layers of abstraction microsoft architectured to provide relational db through cloud platform ?
which backup strategy you are following at ur company
What is an expression in ms sql server?
What is normalization? Explain its different types?
What are the database roles? : sql server security
Explain the functionalities that views support?
Can a database be shrunk to 0 bytes, if not, why?
How to create an index on a view?
What is an indexing technique?
Why union all is faster than union?
List out some of the requirements to set up a sql server failover cluster?
Can we delete data from a view?
