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:

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

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'

Get Your Diploma! W3Schools' Online Certification Program is the perfect solution for busy professionals who need to balance work, family, and career building. The HTML Certificate is for developers who want to document their knowledge of HTML, XHTML, and CSS. The ASP Certificate is for developers who want to document their knowledge of ASP, SQL, and ADO.

Jump to: Top of Page or HOME or Printer friendly page

W3Schools provides material for training only. We do not warrant the correctness of its contents. The risk from using it lies entirely with the user. While using this site, you agree to have read and accepted our terms of use and privacy policy.

Copyright 1999-2008 by Refsnes Data. All Rights Reserved.

W3Schools was converted to XHTML in December 1999