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.
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.
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