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' |
Need an easy way to get data into XML, or transform XML to another format?
MapForce lets you map XML data to/from any combination of XML, database, flat file, Excel 2007, XBRL, or Web services data.
Then it transforms data instantly or auto-generates royalty-free data integration code for recurrent conversions.
New features in Version 2010!
Download a free, fully functional 30-day trial to experience the following features:
- Easy-to-use, graphical data mapping interface
- Instant data transformation
- XSLT 1.0/2.0 and XQuery code generation
- Java, C#, and C++ code generation
- Advanced data processing functions
- Support for all major relational databases including SQL Server, IBM DB2, Oracle, and more
- Visual Studio & Eclipse integration
Download a fully-functional trial today!
|
|
|
|
