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.

• « Previous page
• Next page »