SQL Tutorial

SQL Statements

SQL SELECT Statement

Shows you how to select data from database tables using the SQL SELECT statement.

SQL WHERE Clause

SQL WHERE clause is used with SQL SELECT statement to specifies the search conditions of a query.

SQL INSERT Statement

SQL INSERT statement allows you to insert one or more rows into a database table.

SQL UPDATE Statement

SQL UPDATE statement allows you to modify the existing records of a database table.

SQL DELETE Statement

SQL DELETE statement allows you to delete one or more rows from an existing database table.

SQL GROUP BY Clause

SQL GROUP BY clause as its name imply, returns a group of rows.

SQL HAVING Clause

SQL HAVING clause allows you to limit groups of returned result set.

SQL ORDER BY Clause

SQL ORDER BY clause allows you to sort the data set returned from database server in both ascending and descending order.

Using SQL JOIN Clause

SQL JOIN clause allows you to select data from more than two tables. Here you can learn how to use JOIN, LEFT JOIN and RIGHT JOIN.

Using SQL LIKE

SQL LIKE keyword is used to search string in a column of database table based on pattern matching.

Using SQL IN

SQL IN keyword allows you to limit the result set in a specified value list.

Using SQL BETWEEN

SQL BETWEEN keyword allows you to select a group of data in ranges of two values.

SQL TRUNCATE TABLE Statement

SQL TRUNCATE TABLE statement is used to drop table and recreate it.