Retrieval Queries in MySQL (Select Statements)

Select Syntax is a query method use to retrieve data records.


Download database here: http://www.ziddu.com/download/20022849/RetrieveQuerydatabase.txt.html

::EXAMPLES::

Simple SQL Queries:
SELECT       age
FROM          customer
WHERE        name='Sarah Goodman';

Use of Aliases:
SELECT       S.Fname, S.Lname, E.Fname,   E.Lname 
FROM          Student S E 
WHERE        S.ID=E.ID

Unspecified where clause:
SELECT       name
FROM          customer;

Use of *:
SELECT           *
FROM              customer
WHERE            gender='M';

Use of distinct:
SELECT      DISTINCT name
FROM         customer;

Set operation:
(SELECT     name
FROM         customer
WHERE       gender='M';)
UNION
(SELECT      age
FROM          customer
WHERE        gender='F');

Nested queries:
SELECT       Fname, Lname
FROM          Student
WHERE        ID IN  (SELECT  Dnumber
FROM          Department
WHERE        Dname='ComSci' )


Substring Comparison:
SELECT        gender
FROM          customer
WHERE        name
LIKE            'Sarah Goodman';