Skip to content
Q60Section DA (Data Science and Artificial Intelligence (Q11–Q65))60 of 65

Counting rows returned by a rank-comparison SQL query

Let Account be a relation as shown.

| AccNo | Balance | |—|—| | A1 | 5000 | | A2 | 5000 | | A3 | 10000 | | A4 | 15000 | | A5 | 18000 |

Consider the given SQL query.

SELECT AccNo FROM Account AS A
WHERE (SELECT COUNT(*) FROM Account AS B
WHERE A.Balance < B.Balance) >= (SELECT COUNT(*)
FROM Account AS C WHERE A.Balance > C.Balance)

The number of rows returned by the SQL query is __________ . (Answer in integer)

Numerical answer: type the number (no options).

Type your answer and check it.