Question

271 viewsMay 27, 2023Officesql-server

0

Sandhya 2.52K May 26, 2023 0 Comments

Give an syntax for subquery in SQL server?

score 0 · Answer 1 · 2023-05-27T09:08:18+00:00

SQL – Sub Queries

Subqueries must be enclosed within parentheses.
A subquery can have only one column in the SELECT clause, unless multiple columns are in the main query for the subquery to compare its selected columns.
An ORDER BY command cannot be used in a subquery, although the main query can use an ORDER BY.

Questions