Skip to content
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

Something unclear? Report this question.

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.