SQL Exercises

















Home
SQL Basics:

SQL HOME
SQL Introduction
SQL Select
SQL Where
SQL And & Or
SQL Between
SQL Distinct
SQL Order By
SQL Try It
SQL Insert
SQL Update
SQL Delete
SQL Count

SQL Advanced:

SQL Functions
SQL Group By
SQL Aliases
SQL Join
SQL Create
SQL Alter

SQL Quiz Test

Resources:

SQL Books












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:




CompanyNameContactNameAddressCity




Alfreds Futterkiste

Maria Anders

Obere Str. 57

Berlin





Antonio Moreno Taquería

Antonio Moreno

Mataderos 2312

México D.F.





Berglunds snabbköp

Christina Berglund

Berguvsvägen 8

Luleå





Ernst Handel

Roland Mendel

Kirchgasse 6

Graz





North/South

Simon Crowther

South House
300 Queensbridge

London





Romero y tomillo

Alejandra Camino

Gran Vía, 1

Madrid





Simons bistro

Jytte Petersen

Vinbćltet 34

KÅ‚benhavn





The Big Cheese

Liz Nixon

89 Jefferson Way
Suite 2

Portland





Wolski Zajazd

Zbyszek Piestrzeniewicz

ul. Filtrowa 68

Warszawa







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 * FROM customers







SELECT CompanyName, ContactName
FROM customers







SELECT * FROM customers
WHERE companyname LIKE 'a%'







SELECT CompanyName, ContactName
FROM customers
WHERE CompanyName > 'g'
AND ContactName > 'g'






SELECT * FROM customers








Jump to : Top Of Page or HOME.


We Help you for free. Please Help us!

Help us correct errors
Help us with spelling and grammar
Tell us what you think
Link to us from your pages



All information in this Web is for training only. We do not make any warranties of its correctness or
its fitness to be used. The risk of using it remains with the user.
Copyright © 1999-2001 by Refsnes Data. All Rights Reserved.










More Tutorials:


HTML  XHTML
XML  XSL
CSS  DTD
WAP  WML
JavaScript
DHTML  Flash
VBScript  ASP
SQL  AppML






News:

The Future ofProgramming

Web Security

Browser News

Web Standards






References:

HTML 4.01 Ref

XHTML 1.0 Ref

WML 1.1 Ref

CSS Reference

XSLT Elements

ASCII Reference

Entity Reference

HTML Colors

Color Values

Color Names

WAP Pages






Validation:


HTML  XHTML
CSS  DTD
XML  WML







About W3Scripts

Please link to us








Larger Text?








 XML Partners: