💥 TRENDING: Sql/sql exercises.asp - Complete Album!
SQL Tutorial
SQL HOME SQL Intro SQL Syntax SQL Select SQL Select Distinct SQL Where SQL Order By SQL And SQL Or SQL Not SQL Insert Into SQL Null Values SQL Update SQL Delete SQL Select Top SQL Aggregate Functions SQL Min() SQL Max() SQL Count() SQL Sum() SQL Avg() SQL Like SQL Wildcards SQL In SQL Between SQL Aliases SQL Joins SQL Inner Join SQL Left Join SQL Right Join SQL Full Join SQL Self Join SQL Union SQL Union All SQL Group By SQL Having SQL Exists SQL Any SQL All SQL Select Into SQL Insert Into Select SQL Case SQL Null Functions SQL Stored Procedures SQL Comments SQL OperatorsSQL Database
SQL Create DB SQL Drop DB SQL Backup DB SQL Create Table SQL Drop Table SQL Alter Table SQL Constraints SQL Not Null SQL Unique SQL Primary Key SQL Foreign Key SQL Check SQL Default SQL Create Index SQL Auto Increment SQL Dates SQL Views SQL Injection SQL Parameters SQL Prepared Statements SQL HostingSQL Cert
SQL CertificateSQL References
SQL Data Types SQL KeywordsSQL Examples
SQL Examples SQL Editor SQL Quiz SQL Exercises SQL Server SQL Syllabus SQL Study Plan SQL Bootcamp SQL TrainingSQL Exercises
Test your SQL skills with exercises from all categories:
Exercises
Tip: Sign in to track your progress.
Syntax4 exercises
Select5 exercises
Select Distinct5 exercises
Where6 exercises
Order By6 exercises
And5 exercises
Or5 exercises
Not6 exercises
Insert Into4 exercises
Null Values7 exercises
Update6 exercises
Delete6 exercises
Select Top3 exercises
Min and Max5 exercises
Count4 exercises
Sum5 exercises
Avg5 exercises
Like9 exercises
Wildcards8 exercises
In6 exercises
Between8 exercises
Aliases5 exercises
Joins6 exercises
Inner Join5 exercises
Left Join3 exercises
Right Join3 exercises
Full Join3 exercises
Self Join3 exercises
Union4 exercises
Group By5 exercises
Having5 exercises
Exists3 exercises
Any, All5 exercises
Select Into5 exercises
Insert Into Select4 exercises
CASE Expression3 exercises
NULL Functions5 exercises
Stored Procedures6 exercises
Comments7 exercises
Operators7 exercises
Create Database5 exercises
Drop Database6 exercises
Backup Database5 exercises
Create Table5 exercises
Drop Table7 exercises
Alter Table8 exercises
Constraints5 exercises
Not Null5 exercises
Unique5 exercises
Primary Key4 exercises
Foreign Key5 exercises
Check4 exercises
Default4 exercises
Create Index5 exercises
Auto Increment3 exercises
Dates3 exercises
View6 exercises
Injection4 exercises
Hosting3 exercises
Data Types3 exercises
Log in to track your progress
If you haven't already, sign up to become a W3Schooler, and get points for every exercise you complete.
As a logged-in W3Schools user you will have access to many features like having your own web page, track your learning progress, receive personal guided paths, and more.
The Exercise
The exercises are a mix of "multiple choice" and "fill in the blanks" questions.
There are between 3 and 9 questions in each category.
The answer can be found in the corresponding tutorial chapter.
If you're stuck, or answer wrong, you can try again or hit the "Show Answer" button to see the correct answer.
Get Certified in coding
Complete the W3Schools coding course, strengthen your knowledge, and earn a certificate you can add to your CV, portfolio, and LinkedIn profile.
Contact Sales
If you want to use W3Schools services as an educational institution, team or enterprise, send us an e-mail:
sales@w3schools.com
Report Error
If you want to report an error, or if you want to make a suggestion, send us an e-mail:
help@w3schools.com
Top Tutorials
HTML TutorialCSS Tutorial
JavaScript Tutorial
How To Tutorial
SQL Tutorial
Python Tutorial
W3.CSS Tutorial
Bootstrap Tutorial
PHP Tutorial
Java Tutorial
C++ Tutorial
jQuery Tutorial
Top References
HTML ReferenceCSS Reference
JavaScript Reference
SQL Reference
Python Reference
W3.CSS Reference
Bootstrap Reference
PHP Reference
HTML Colors
Java Reference
AngularJS Reference
jQuery Reference
Tutorials, references, and examples are constantly reviewed to avoid errors, but we cannot warrant full correctness
of all content. While using W3Schools, you agree to have read and accepted our terms of use, cookies and privacy policy.
Copyright 1999-2026 by Refsnes Data. All Rights Reserved. W3Schools is Powered by W3.CSS.