Let Account be a relation as shown.
Consider the given SQL query.
The number of rows returned by the SQL query is __________ . (Answer in integer)

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

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)
5A GATE question every morning
One real past-paper question every morning for your branch, answer hidden until you tap. Free on Telegram.