Login

Username:

Password: 

Join us Now |  Forgot Password? | Forgot UserName?

SQL

Learn step by step



SQL SELECT Statement

In SQL statement SELECT is the SQL command that retrieves data from an SQL database.
This operation is also known as query and it is the key to the use of SQL for reporting and analysis.
Syntax

SELECT <columnlist>
FROM <tablename>


SELECT productNumber, productName
FROM product

Output

productNumberproductName
101 laptaop
102 Desktop
103 Tablet
2001 Data Modeling Tool Professional


SELECT *
FROM product

Output

productNumber productName productCode startDate endDate rawMaterialCost
101 laptaop P-001 20/12/1990 01/01/1992 25635
102 Desktop P-002 02/02/2014 01/01/2015 15005
103 Tablet P-056 02/02/2014 01/01/2015 7000
1030 HDD ST-056 02/02/2014 01/01/2015 3000


Related Videos