GATE DA 2026 — Question 60

Database Management and Warehousingrelational model: relational algebra, tuple calculus, SQLNAT2 marksMedium

Let Account be a relation as shown.
Question image
Consider the given SQL query.
sql
1SELECT AccNo FROM Account AS A
2WHERE (SELECT COUNT(*) FROM Account AS B
3WHERE A.Balance < B.Balance) >= (SELECT COUNT(*)
4FROM Account AS C WHERE A.Balance > C.Balance)
5
The number of rows returned by the SQL query is __________ . (Answer in integer)
Practise the full 2026 paper
Challenge a friend: WhatsApp Telegram
Recommended book · affiliate linkDatabase System Concepts (Korth)Normalisation, SQL, transactions and indexing — the DBMS syllabus in one book.
Practise more on relational model: relational algebra, tuple calculus, SQLTimed, in the real exam interface · free to start

A GATE question every morning

One real past-paper question every morning for your branch, answer hidden until you tap. Free on Telegram.

Join
Stuck? Ask in the student group