| |
|
Write down some properties of SubQuery In SQL?
Question Posted on 28 Jun 2022
Home >> DataBase >> sql questions >> Write down some properties of SubQuery In SQL? |
Write down some properties of SubQuery In SQL?
First we will mention something about SubQuery, its a query which can be nested inside the main query like Update, Insert, Delete and Select staements. And we can used when expression is allowed. Below are the four main properties of subquery:-
(1)We should take care that sub query should not have order by clause.
(2)We can use more than one sub query.
(3)We should take care that sub query should be enclosed in parenthesis reason behind this is that it should be executed first before the main query.
(4)We should take care that sub query should be placed in the right hand side of the comparison operator of the main query
A sub query should be enclosed in parenthesis because it needs to be executed first before the main query. | |
|
|
|
|