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
- 11962 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
how to use DTS package in 2000,2005,2008 in sql server
When do you think a developer should use sql server-based cursors?
What is the difference between for trigger and after trigger?
How to check if stored procedure is running in sql server?
Define full outer join?
What is the native system stored procedure to execute a command against all databases?
Define union, union all, minus, intersect?
How to find table changes in sql server?
How to convert numeric values to integers in ms sql server?
How use inner join in sql server?
What is the status of services on passive node for failover cluster in sql server? : sql server database administration
Is t sql the same as sql server?
What do you mean by stored techniques? How would we use it?
What is a cube? : sql server analysis services, ssas
Explain the use of containers in ssis?
