All Type Coding

Search Here

How to use select statement in sql server.?


Select Statement

Select command or statement is used to fetch all or selected column from a database table.
Syntax
             Select * from table_Name
Now how will select all data column from a database table to step by step
Step1.Create a table.in our previous tutorials we have created a table
Step2.Insert the data into the table like below image.
The givin above query display the all column or fields data from tha database table.



























Step3 Now Execute the select command.
         Select * from Employee1 
output will be like this.









if you want to see only selected column then write the select statement like below.
              Select Name,Salary,Gender from Employee1
The above query give the output like below.




































No comments :

Post a Comment