Let Account be a relation as shown. Account AccNo Balance A1 5000 A2 5000 A3…
GATE · 2026 · DA · Data Science & AI
Let Account be a relation as shown.
Account
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)
Attempted by 5 students.
Sign up free to check your answer
Sign up freeLoading lesson…