-
Shows you how to select data from database tables using the SQL SELECT statement
-
SQL WHERE clause is used with SQL SELECT statement to specifies the search conditions of a query
-
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 divides a table into sets and it usually use with SQL aggregate functions which produces summary value for each set.
-
SQL HAVING clause allow you to limit groups of returned result set
-
SQL BETWEEN allows you to select a group of data in ranges of two values.
-
SQL LIKE is used to search string in a column of database table based on pattern matching.
-
SQL IN allows you to limit the result set in a specified value list.
-
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 allows you to insert one or more rows into a table
-
SQL UPDATE statement allows you to modify the existing record(s) of database table
-
SQL DELETE statement allows you delete one or more rows from an existing database table
-
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.