All for Joomla All for Webmasters

SQL SELECT Database

SQL select statement is used to query or retrieve data from a table in the database. It is the most commonly used statement in SQL command.

If you want to retrieve information from specified column or all columns from a table, use SQL SELECT query.

The basic syntax of SQL SELECT statement is given below:

  1. SELECT column_list FROM table_name
  2. [WHERE Clause]
  3. [GROUP BY Clause]
  4. [HAVING Clause]
  5. [ORDER BY Clause];

The example of select statement is given below:

  1. SELECT firstname,lastname,salary FROM employee;
PinIt
submit to reddit

Leave a Reply

Top