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.