Sponser Link

SQL Server Select Query

In this Tutorial, we will learn select the data from SQL table. You can fetch the data from multiple tables (we will discuss in next tutorial). Syntax is given below.


 SELECT col1,col2,col3 FROM Table1
 Where col1=value

Or you can select * FROM Table1 instead of columns name.

If you want to see all data then you can remove the WHERE clause.

Complete example is given below.

 
SELECT item_Number,Total_Amount FROM salesTransaction
 Where Unit_Price>100