SELECT — The basis of the SQL language — Parv The IT Geek

The SELECT query is the basis of SQL and is the most commonly used syntax within SQL.

SELECT basically means retrieve.

For example the query SELECT 1 returns 1.

SELECT ‘This is an example of the SELECT statement’

As you can see the SELECT query is simply retrieving the number or word and returning that as a result.

If you want information from a database within a table then you must select a database and table.

SELECT * FROM YourTableName

Originally published at https://parvtheitgeek.com on November 5, 2013.