SQL – SELECT
SQL – SELECT Statement :
Sql Select Statement is used to fetch records from database table.
SQL – SELECT Syntax 1 (Select All Columns) :
SELECT *FROM TableName;
SQL – SELECT Syntax 2 (Select few Columns) :
SELECT ColumnName1, ColumnName2, ColumnName3,…. FROM TableName;
SQL Select All Columns Example :
Example
SELECT * FROM Users;
The above Query will display the results as :
Select-all-c…ql-query
SQL Select Few Columns Example :
Example
SELECT ID, Name, Email FROM Users;
The above Query will display the results as :
Advertisements
Add Comment
📖 Read More
- 1. SQL - WHERE Clause
- 2. SQL - AND & OR
- 3. SQL ORDER BY
- 4. SQL - UPDATE
- 5. SQL - DELETE
- 6. SQL - Like
- 7. SQL In Operator
- 8. SQL Between
- 9. SQL Joins - INNER JOIN
- 10. SQL - LEFT JOIN
