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
- 11820 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 kind of lan types do you know? : Sql server database administration
Explain error handling in ssis?
Write the syntax for stuff function in an sql server?
Do you know hot add cpu in sql server 2008?
What are scalar functions in sql?
What is the difference between system objects and user objects?
Why should one not prefix user stored procedures with ‘sp_’?
Write the SQL query to drop, truncate and delete table.
What are logical database components? : SQL Server Architecture
Why truncate is ddl?
What are the differences between local and global temporary tables?
Can a table have 2 primary keys?
Explain cursor as data base object?
Give an example of why you would want to denormalize a database
What is impersonation? What are the different impersonation options available in ssas? : sql server analysis services, ssas
