SQL SELECT Essentials Quiz

Froggy Jumps

Played 4 %Accuracy 45 Average time 01:51

Create copy

About this activity

Test your SQL SELECT knowledge.

Created by

Teresa

United Kingdom

Download the paper version to play

Top 10 results

#	Player	Accuracy	time
1	Teresa February 20, 2026	% 55	02:20

Do you want to stay in the Top 10 of this game? Log in to identify yourself.

Make your own free game from our game creator

Compete against your friends to see who gets the best score in this game

Make challenge

The Integumentary System

Breanna Nesbitt

United States

(58)

Functions and Structures of the skin
Ethos, Pathos, and Logos Quiz

Kristine Vester

United States

(131)

Test your knowledge of ethos, pathos, and logos with these 10 questions on examples of persuasive techniques.
pizza

Lorelay Tyana

Romania

(258)

joc despre pizza
Bill of Rights Game - The Constitutionalist

Doni The Don

United States

(89)

Test your knowledge on the Bill of Rights. A fun way to test your knowledge and focus on where you need to improve.
Phlebotomy Order of Draw Quiz

Pamela Chapman

United States

(59)

Test your knowledge of the order of draw in Phlebotomy with these 10 questions!

		%
	Anonymous	%
		%
		%

Print your game

SQL SELECT Essentials Quiz


Froggy Jumps SQL SELECT Essentials QuizOnline version Test your SQL SELECT knowledge. by Teresa 1 Which clause lists the columns to return in a SELECT statement? a WHERE list b FROM list c SELECT list 2 Which keyword returns only distinct values from a column? a SELECT DISTINCT b SELECT SEPARATE c SELECT UNIQUE 3 Which clause limits rows to a subset based on a condition? a FILTER b HAVING c WHERE 4 Which clause sorts the result set by one or more columns? a SORT b ORDER BY c GROUP BY 5 Which operator pattern uses % to match multiple characters in LIKE? a % b _ c ~ 6 Which keyword returns the first N rows of a query (depending on DB)? a SELECT TOP b SELECT FIRST c SELECT LIMIT 7 Which operator selects records matching any of several values in IN? a ANY (value1, value2) b IN (value1, value2, ...) c MATCH (value1, value2) 8 Which operator filters a range of values inclusively? a RANGE b INSIDE c BETWEEN 9 Which clause can combine multiple conditions with AND/OR and parentheses? a JOIN b HAVING c WHERE 10 What is the purpose of the SELECT statement in SQL Server? a To modify data in a table b To define a database schema c To retrieve data from one or more tables 11 Which clause lists the columns to return in a SELECT? a WHERE list b SELECT list c FROM list 12 What does SELECT * FROM table do? a Returns all columns from the table b Deletes all rows in the table c Returns only the first column 13 Which keyword returns only distinct values? a SELECT UNIQUE b SELECT DISTINCT c SELECT DIFFERENT 14 Which clause limits returned rows with a condition? a GROUP BY b HAVING c WHERE 15 Which operator sorts results in descending order by default? a ORDER BY with DESC b ORDER BY ASC c SORT DESC 16 What does the TOP clause do in SELECT? a Deletes top rows b Limits the number or percent of rows returned c Creates a new table of top rows 17 Which operators combine conditions with AND/OR? a Bitwise operators b Logical operators c Arithmetic operators 18 Which clause filters groups after GROUP BY? a HAVING b ORDER BY c WHERE 19 Which pattern-matching operator searches for a text pattern? a MATCH b COMPARE c LIKE

You can integrate the game into an LMS compatible with LTI 1.1 or LTI 1.3 such as Canvas, Moodle, or Blackboard. This way, the scores will be automatically saved into the platform’s gradebook.

SQL SELECT Essentials Quiz

Froggy Jumps

About this activity

Created by

Download the paper version to play

Top Games

Froggy Jumps

The Integumentary System

Froggy Jumps

Ethos, Pathos, and Logos Quiz

Froggy Jumps

pizza

Froggy Jumps

Bill of Rights Game - The Constitutionalist

Froggy Jumps

Phlebotomy Order of Draw Quiz

Froggy Jumps

SQL SELECT Essentials QuizOnline version

by Teresa

Which clause lists the columns to return in a SELECT statement?

Which keyword returns only distinct values from a column?

Which clause limits rows to a subset based on a condition?

Which clause sorts the result set by one or more columns?

Which operator pattern uses % to match multiple characters in LIKE?

Which keyword returns the first N rows of a query (depending on DB)?

Which operator selects records matching any of several values in IN?

Which operator filters a range of values inclusively?

Which clause can combine multiple conditions with AND/OR and parentheses?

What is the purpose of the SELECT statement in SQL Server?

Which clause lists the columns to return in a SELECT?

What does SELECT * FROM table do?

Which keyword returns only distinct values?

Which clause limits returned rows with a condition?

Which operator sorts results in descending order by default?

What does the TOP clause do in SELECT?

Which operators combine conditions with AND/OR?

Which clause filters groups after GROUP BY?

Which pattern-matching operator searches for a text pattern?