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 free

Explore the full course: Gate Guidance By Sanchit Sir

Loading lesson…