SELECT syntax

Subqueries are not supported in a SELECT list and the PERCENT argument is not supported in the TOP clause.

Examples

Example A

The nested SELECT statement in the following statement is not supported.

SELECT
(SELECT a.empno FROM emp a WHERE a.deptno = b.deptno)
FROM
dept b

Example B

The PERCENT argument is not supported in a TOP clause.

SELECT TOP 10 PERCENT * FROM emp ORDER BY sal desc

Example C

The TOP clause is not supported in UNION queries and subqueries.

SELECT TOP 3 empno FROM emp UNION SELECT deptno FROM dept;
SELECT * FROM emp WHERE deptno IN (SELECT TOP 2 deptno FROM dept);