Q: A subquery in an sql select statement.
- Show Answer
- Workspace
- Discuss
Answer :
Explanation :
A Subquery or Inner query or a Nested query is a query within another SQL query and embedded within the WHERE clause. Subqueries are most frequently used with the SELECT statement. The basic syntax is as follows:: SELECT column_name [, column_name ]FROM table1 [, table2 ]WHERE column_name OPERATOR(SELECT column_name [, column_name ]FROM table1 [, table2 ][WHERE]) A subquery is used to return data that will be used in the main query as a condition to further restrict the data to be retrieved. Subqueries can be used with the SELECT, INSERT, UPDATE, and DELETE statements along with the operators like =, , >=,
Similar Questions
Since Nithya and Suganya exchange places, so Rita’s new position is the same as Monika’s earlier position. This position is 17th from the right and 10th from the left. Therefore Number of girls in the row = (16 + 1 + 9) = 26.