Low cost ecommerce web development India flash website design

The SELECT Statement
The SELECT statement retrieves data from the database. To retrieve the data,
you specify a field list, a table list, a list of fields to sort by, and the sort order.
The parts of a SQL statement are called clauses. A basic SELECT statement
has up to four clauses. For example:
SELECT (fieldl [, field2] ...)
FROM (table1 [, table2] ...)
WHERE (condition1 [, condition2] ...)
ORDER BY (fieldl [ASC|DESC] [, fie1d2 [ASC|DESC]] ...)
The WHERE and ORDER BY clauses are optional. If you omit the WHERE
clause, the query returns all rows from the specified tables. If you omit the
ORDER BY clause, SQL retrieves rows in the sequence in which they're
stored in a table. By default, when you retrieve data from multiple tables,
SQL uses the row order from the first specified field.
At the most basic level, you can obtain all the information from a table using
an asterisk (*) as a shorthand way of specifying all fields.

Of course, you don't have to select all fields, you can specify the exact fields
and field order that you wish.