by, 03-09-2012 at 08:27 PM (645 Views)
SQL is considered to be a query language which has been designed for using it with relational databases. Standard SQL commands set is present which is used along with all relational DMS i.e. database management system. All relational DBMS use select statement.
Information is obtained from a table by select statement. This is also known as a query. Following is specified by it.
- 1 or more columns
- Selection criteria
- 1 or more tables
First & last names of the employees owing company’s car will be obtained by the following select statement.
SELECT First_Name, Last_Name
WHERE Car_Number IS NOT NULL