SQL Select statement in database systems

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

 

Add a Comment