Text copied!
SELECT clause
SQL clause is the specific part of a SQL statement which is used to perform various operations. It can be combined to create more complex queries to retrieve and manipulate data.
SELECT clause :
SELECT clause is used to retrieve/get data from table(s) in the database. It is often used with other clauses such as 'FROM', 'WHERE' and 'ORDER BY' etc. to specify table, filter, sort and manipulate data.
The syntax of the SELECT clause generally looks like this :
SELECT column_name(s)
FROM table_name;
• Specify the column(s) name after the 'SELECT' keyword.
• Specify Asterisk (*) symbol to selects all columns from the table after the 'SELECT' keyword.
• Specify the table name after the 'FROM' keyword.
Here's an example of how you might use the SELECT clause :
1. Let's assume we have a table named "[Product]".
2. Let's retrieve all columns and rows from the this table >> Run below SQL statement :
SELECT *
FROM [Product];
2. Above statement will select all the data from the [Product] table.
That's it! You have successfully retrieved all data from [Product] table.
Here's an another example of how you might use the SELECT clause :
1. Suppose we want to retrieve only specific columns from the [Product] table.
2. Run below SQL statement :
SELECT [ProductID], [Name], [ProductNumber]
FROM [Product];
3. Above statement will select only [ProductID], [Name] and [ProductNumber] columns from the [Product] table.
That's it! You have successfully selected [ProductID], [Name] and [ProductNumber] columns from [Product] table.
Here's the third example of how you might use the SELECT clause :
1. Suppose we want to retrieve only specific number of rows from the [Product] table.
2. Run below SQL statement :
SELECT TOP 3 *
FROM [Product];
3. Above statement will select only top 3 rows from the [Product] table.
That's it! You have successfully retrieved top 3 rows from [Product] table.