What is sub-query in sql server? Explain its properties.
- 1 Answers
- 1161 Views
- I also Faced
- E-Mail Answers
Answer Posted / Pooja Rani Vishnoi
A sub-query, also known as an inner query, is a SQL statement that is nested inside another SQL statement. It can return a single value or multiple values. Sub-queries can be used to filter data, join tables, aggregate data, and perform complex queries. There are two main types of sub-queries: correlated sub-queries and non-correlated sub-queries.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What are the properties of the transaction?
Why and when do stored procedure recompile?
What is standby servers? Explain types of standby servers.
How raid can influence database performance?
Can you index views?
How to convert numeric expression data types using the cast() function?
If any stored procedure is encrypted, then can we see its definition in activity monitor?
explain different types of backups avaialabe in sql server? Given a particular scenario, how would you go about choosing a backup plan? : Sql server database administration
Explain “row_number()” in sql server with an example?
What is self contained sub query?
How to remove duplicate rows from table except one?
You have a stored procedure, which execute a lengthy batch job. This stored procedure is called from a trigger you do not want to slow the data entry process you do not want trigger to wait for this batch job to finish before it completes itself what you can do to speed up the process?
Why use identity in sql server?
What is sql server query analyzer?
What are the kinds of subquery?
