The SQL SELECT statement is used in the SQL command and it's is used in the database to retrieve the selected data by the conditions in queries.

sql select statement



In the SQL select statements have wanted to select data from one or more tables by the basic syntax.

This syntax for a single table :

 

  
SELECT  
columns_list or select 
FROM
table_name;

  
  

Here, the columns_list are the fields that table values want to retrieves.

If we want to fetch all the data from the table then you can use the Asterix '*' and follow the syntax.
And this is the shorthand for calling all the columns in the table.

 

 

  
SELECT * FROM table_name;
   
  

Here I created a table named as customers in SQL Server 
 
Here the sample table Database to Download 
 

cust_id cust_name age city
1 Rahul 18 vellore
2 Anbu 26 chennai
3 Aravindh 26 chennai
4 chandra 24 vellore
5 priya 22 pune




Here I get customers table to for demonstration purposes for example sample table database

 

Customer Table:

customer Table
customer_Id(primary key)
customer_name
Age
city


SELECT * FROM customers;

cust_id cust_name age city
1 Rahul 18 vellore
2 Anbu 26 chennai
3 Aravindh 26 chennai
4 chandra 24 vellore
5 priya 22 pune


SQL SELECT: 


An select data from the specific columns, in the table and select data customer_name , Age,city in the customers table.


SELECT
cust_name,
age,
city
FROM
customers;


Now, Execute the code and the results is below: 


cust_name age city
Rahul 18 vellore
Anbu 26 chennai
Aravindh 26 chennai
chandra 24 vellore
priya 22 pune

Post a Comment

Previous Post Next Post