College Subject Practice · College Year 2
SQL practice questions — College Subject Practice · College Year 2 Database Systems
Practise SQL with topic-based questions. Preview a sample, then start a short session.
See the question style before signup · Get instant feedback · Continue with focused practice
Try a sample question
Check your answer to see the explanation where one has been published.
Try this question
In a window function, what does an empty OVER () clause (no PARTITION BY, no ORDER BY) imply?
1 sample question · No signup needed
2
Consider SELECT SUM(amount) OVER (PARTITION BY cust ORDER BY dt) FROM orders. What does this compute?
3
Which pair of operands is required for INTERSECT to work correctly?
Start a sample session
50 published questions available for this topic.