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'
|
Make your web applications look like a million bucks
|
|
Most web applications today use boring methods to present data to their viewers using grids or simple HTML tables. FusionCharts induces "life" into the web applications by converting monotonous data into lively charts, gauges & maps.
FusionCharts works with all technologies like ASP, ASP.NET, PHP, ColdFusion, Ruby on Rails, JSP, HTML pages etc.
and connects to any database to render animated & interactive charts. It takes less than 15 minutes and no expertise
whatsoever to build your first chart and just a glance of it to captivate your audience. This fact is endorsed by our
12,000 customers and 150,000 users which include a majority of the Fortune 500 companies.
And yeah, your applications could look like a million bucks by spending just $69.
So go ahead, download your
copy of FusionCharts and start "wow-ing" your customers now!
|
|
