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' |
Start Creating a stunning, Flash website. It's easy and free!
Wix.com offers you a simple, powerful, drag & drop editing platform to create stunning Flash websites, layouts, and more.
With added e-commerce features such as search engine visibility and professional tools, Wix is the ultimate solution for creating a spectacular site.
 |
W3Schools' Online Certification Program
The perfect solution for professionals who need to balance work, family, and career building.
More than 4500 certificates already issued!
|
The HTML Certificate documents your knowledge of HTML, XHTML, and CSS.
The JavaScript Certificate documents your knowledge of JavaScript and HTML DOM.
The XML Certificate documents your knowledge of XML, XML DOM and XSLT.
The ASP Certificate documents your knowledge of ASP, SQL, and ADO.
The PHP Certificate documents your knowledge of PHP and SQL (MySQL).
|