SQL Try It
Test your SQL Skills
On this page you can test your SQL skills.
We will use the Customers table in the Northwind database:
| CompanyName |
ContactName |
Address |
City |
| Alfreds Futterkiste |
Maria Anders |
Obere Str. 57 |
Berlin |
| Berglunds snabbköp |
Christina Berglund |
Berguvsvägen 8 |
Luleå |
| Centro comercial Moctezuma |
Francisco Chang |
Sierras de Granada 9993 |
México D.F. |
| Ernst Handel |
Roland Mendel |
Kirchgasse 6 |
Graz |
| FISSA Fabrica Inter. Salchichas S.A. |
Diego Roel |
C/ Moralzarzal, 86 |
Madrid |
| Galería del gastrónomo |
Eduardo Saavedra |
Rambla de Cataluña, 23 |
Barcelona |
| Island Trading |
Helen Bennett |
Garden House Crowther Way |
Cowes |
| Königlich Essen |
Philip Cramer |
Maubelstr. 90 |
Brandenburg |
| Laughing Bacchus Wine Cellars |
Yoshi Tannamuri |
1900 Oak St. |
Vancouver |
| Magazzini Alimentari Riuniti |
Giovanni Rovelli |
Via Ludovico il Moro 22 |
Bergamo |
| North/South |
Simon Crowther |
South House 300 Queensbridge |
London |
| Paris spécialités |
Marie Bertrand |
265, boulevard Charonne |
Paris |
| Rattlesnake Canyon Grocery |
Paula Wilson |
2817 Milton Dr. |
Albuquerque |
| Simons bistro |
Jytte Petersen |
Vinbæltet 34 |
København |
| The Big Cheese |
Liz Nixon |
89 Jefferson Way Suite 2 |
Portland |
| Vaffeljernet |
Palle Ibsen |
Smagsløget 45 |
Århus |
| Wolski Zajazd |
Zbyszek Piestrzeniewicz |
ul. Filtrowa 68 |
Warszawa |
To preserve space, the table above is a subset of the Customers table used in
the example below.
Try it Yourself
To see how SQL works, you can copy the SQL statements below and paste them
into the textarea, or you can make your own SQL statements.
SELECT CompanyName, ContactName
FROM customers
|
SELECT * FROM customers
WHERE companyname LIKE 'a%'
|
SELECT CompanyName, ContactName
FROM customers
WHERE CompanyName > 'a'
|
 When using SQL on text
data, "alfred" is greater than "a" (like in a dictionary).
SELECT CompanyName, ContactName
FROM customers
WHERE CompanyName > 'g'
AND ContactName > 'g'
|
|
