View RSS Feed

Java Database

SELECT Statements

Rate this Entry
by , 03-09-2012 at 07:27 PM (748 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
FROM Employees
WHERE Car_Number IS NOT NULL

Submit "SELECT Statements" to Facebook Submit "SELECT Statements" to Digg Submit "SELECT Statements" to del.icio.us Submit "SELECT Statements" to StumbleUpon Submit "SELECT Statements" to Google

Categories
SQL

Comments