Retrieving All Data in SQL Data Base
by Dinesh[ Edit ] 2012-08-27 17:18:06
Retrieving All Data in SQL Data Base
SQL select statements are used to retrieve data from SQL databases. Take our free online SQL tutorial and learn SQL. Among the many commands we teach you are the SQL commands used to select and order data contained in a SQL database.
Syntax:
Select *
from tablename;
Explanation:
01. A Select statement is a SQL statement that begins with the word "select."
02. Select statements are used to retrieve data from SQL tables.
03. An asterisk after the word "select" means retrieve all fields (columns).
04. The name of the table from which you are retrieving data is specified in the From clause.
Use a semicolon to signify the end of a SQL statement.
