What is the SELECT statement?
The select statement is used to display the values from the table.
| RollNo | Name | Fee |
| 1 | Sameed | 10,000 |
| 2 | Shahzeb | 10,000 |
| 3 | Basit | 0.00 |
Table 1: student
Example 1:
Query on table 1: SELECT * FROM student;
Result:
| RollNo | Name | Fee |
| 1 | Sameed | 10,000 |
| 2 | Shahzeb | 10,000 |
| 3 | Basit | 0.00 |
Query show the resultant table: student
Example 2:
Query on table 1: SELECT RollNo, Name FROM student;
Result:
| RollNo | Name |
| 1 | Sameed |
| 2 | Shahzeb |
| 3 | Basit |
Query show the resultant table: student
Example 3:
Query on table 1: SELECT RollNo FROM student;
Result:
| RollNo |
| 1 |
| 2 |
| 3 |
Query show the resultant table: student