 |
| SQL Introduction |
| SQL (Structured Query Language) is a widely used database language, providing means of data manipulation (store, r...more » |
|
 |
| |
|
|
| SQL Select |
| The SELECT statement is used to retrieve data from a table. The general form is as under.
Synt...more » |
|
|
| |
|
|
| SQL Where Clause |
| In Select Query we use WHERE clause to select only data that matches a specified criteria.
...more » |
|
|
| |
|
|
| SQL Distinct |
| The SQL DISTINCT command is used along with the SELECT statement. It retrieves only unique data entries depending on the column list you have specified after it. Here is ...more » |
|
|
| |
|
|
| SQL AND Operator |
| The AND operator displays a record if all the conditions are true. It links together two or more conditional statements for increased filtering when running SQL commands.
...more » |
|
|
| |
|
|
| SQL OR Operator |
| The OR operator displays a record if one of the conditions is true. an Or condition just asks SQL to look for 2 separate conditions within the same query and return any records ma...more » |
|
|
| |
|
|
| SQL Order By |
| The Order By keyword is used to sort the result-set of select statement by a specified column name. It will sort the records in ascending or descending order. By default it sorts ...more » |
|
|
| |
|
|
| SQL Insert |
| The INSERT statement allows you to insert a single record or multiple records into a table. The general syntax is as under.
Syntax 1:
...more » |
|
|
| |
|
|
| SQL Update |
| The Update command is used to make changes to records in tables. The general syntax is as under.
Syntax:
UPDATE table_name...more » |
|
|
| |
|
|
| SQL Delete |
| The Delete statement is used to remove records from a table.
Table Name ‘Users’
...more » |
|
|
| |
|
|
| SQL Join |
| Tables in a database are often related to each other with keys. A primary key is a column which has a unique value for each record. It must be unique within the table. The purpose...more » |
|
|
| |
|
|
| SQL Inner Join |
| SQL Inner Join keyword will return the records if there is at least one match in both tables.
Table Name ‘Users’
...more » |
|
|
| |
|
|
| SQL Left Join |
| SQL LEFT Join keyword will returns all records from the left table, even if there are no matches in the right table.
Table Name ‘Users&rsqu...more » |
|
|
| |
|
|
| SQL Right Join |
| SQL RIGHT Join keyword will returns all records from the right table, even if there are no matches in the left table.
Table Name ‘Users&rsq...more » |
|
|
| |
|
|
| SQL Full Join |
| The Full Join keyword will return records if there is a match in one of the tables.
Table Name ‘Users’
...more » |
|
|
| |
|
|
| SQL Create Database |
| The CREATE DATABASE statement is used to create a new database.
Syntax:
CREATE DATABASE database_name
...more » |
|
|
| |
|
|
| SQL Create Table |
| The CREATE TABLE statement is used to create a table in a database.
Syntax:
CREATE TABLE table_name
(...more » |
|
|
| |
|
|
| SQL Constraints |
| Constraints are specified when a table is created. They used to limit the type of data that can go into a table.
Here are some constraints which are comm...more » |
|
|
| |
|
|
| SQL Alter Table |
| The ALTER TABLE statement is used to add, delete, or modify columns in an existing table.
Syntax (To add a column in a table):...more » |
|
|
| |
|
|
| SQL Truncate Table |
| The Truncate Table statement is used to delete the data inside the table. It will delete all rows from the table.
Syntax:
...more » |
|
|
| |
|
|
| SQL Drop |
| SQL Drop Table
The DROP TABLE statement is used to delete a table.
Syntax:
...more » |
|
|
| |
|
