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 ORDER BY Clause

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

SQL GROUP BY Clause

SQL GROUP BY clause divides a table into sets and it usually use with SQL aggregate functions which produces summary value for each set.

SQL HAVING Clause

SQL HAVING clause allow you to limit groups of returned result set

Using SQL BETWEEN

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

Using SQL LIKE

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

Using SQL IN

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

Using SQL JOIN - SQL JOIN tutorial

In real world programming contexts, you usually need to select data from two or more than two tables to make your result complete. in such cases, you need SQL JOIN.

SQL INSERT Statement

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

SQL UPDATE Statement

SQL UPDATE statement allows you to modify the existing record(s) of database table

SQL DELETE Statement

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

TRUNCATE TABLE Statement

SQL TRUNCATE statement is used to delete all data from a table without WHERE condition. SQL TRUNCATE statement drops the table and recreate it again.

Search