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
- 11747 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
What does this statement do @@rowcount?
What is the security model used in sql server 2005?
how you can get the list of largest tables in a database? : Sql server administration
What is the language structure to add a record to a table?
What is store procedure? When do you use?
What is perspective, have you ever created perspective? : sql server analysis services, ssas
What is the purpose of object explorer and its features? : sql server management studio
Explain what are the events recorded in a transaction log?
What is the simplest way to create a new database in ms sql server?
What is join and name different type of joins?
How many databases can we create in a single server?
Describe how to use linked server?
What is in place upgrade in sql server?
Can you explain powershell included in sql server 2008?
Write a SQL queries on Self Join and Inner Join.
