Low cost ecommerce web development India flash website design

Programmers moving from file-based databases to relational databases often
make the mistake of thinking that the simple SELECT statement is all they
need. They are accustomed to scrolling (moving sequentially from field to
field) through a set of records to find the info they need. That's absolutely the
wrong way to approach relational databases. Don't search for records yourself
— let the database do the work. That's what the WHERE clause does — it
limits the returned records to exactly the ones you need
The ORDER BY clause of the SELECT statement controls the order of the
records returned by the query.
The fields in the ORDER BY clause do not have to appear in the selected
field list. The default sort order is ascending (ASC), but you can retrieve
fields in reverse order by specifying the DESC keyword after the appropriate
field name. You don't have to select all the fields, and you may select them in
any order you desire.

The following SELECT statement includes all the basic SELECT clauses:
SELECT StudentID, LastName, FirstName
FROM Students
ORDER BY Grade DESC