Please visit our sponsors !

SQL Tutorial

SQL Tutorial

SQL is an ANSI standard language for accessing databases! In our SQL tutorial you will learn how to use SQL to access, define, and manipulate the data in a database system, like Oracle, DB2, Sybase, Informix, Microsoft SQL Server, Access, and others. Start Learning SQL!

SQL Quiz Test

Test your SQL skills at W3Schools! Start SQL Quiz! 

Table of Contents

SQL Basic

SQL Introduction 
This chapter describes what SQL is, and how it can be used.

SQL Select 
How to use the SELECT statement to select data from a table in SQL.

SQL Where 
How to use the WHERE clause to specify a criterion for the selection.

SQL And & Or 
How to use AND and OR to join two or more conditions in a WHERE clause.

SQL Between
How to use BETWEEN....AND to find data in a range.

SQL Distinct
How to use the DISTINCT keyword to return only different values in a column. 

SQL Order By
How to use the ORDER BY keywords to return rows in a defined order. 

SQL Try It
Test your SQL skills! 

SQL Insert
How to use the INSERT statement to insert new rows into a table.

SQL Update
How to use the UPDATE statement to update or change rows in a table.

SQL Delete
How to use the DELETE statement to delete rows in a table.

SQL Count
This chapter explains how to use the built-in COUNT functions in SQL.

SQL Advanced

SQL Functions
This chapter explains how to use the built-in functions in SQL.

SQL Group By
This chapter explains how to use the built-in GROUP BY function in SQL.

SQL Aliases
This chapter explains how to use aliases for column names and table names.

SQL Join 
How to use select information from more than one table.

SQL Create
How to create databases and tables, and how to delete them.

SQL Alter
How to use the ALTER TABLE statement to add or drop columns in an existing table.

SQL Quiz

SQL Quiz Test
Test your own SQL skills!

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

Search W3Schools:

What Others Say About Us

Does the world know about us? Check out these places:

Dogpile Alta Vista MSN Google Excite Lycos Yahoo Ask Jeeves

We Help You For Free. You Can Help Us!

• Tell your newsgroup or mailing list
• Link to us from your pages
• Help us correct errors and broken links
• Help us with spelling and grammar
• Validate the XHTML code of this page

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

Copyright 1999-2002 by Refsnes Data. All Rights Reserved

How we converted to XHTML