SQL Select statement in database systems

What is the SELECT statement?

The select statement is used to display the values from the table.

RollNoNameFee
1Sameed10,000
2Shahzeb10,000
3Basit0.00

Table 1: student

Example 1:

Query on table 1: SELECT * FROM student;

Result:

RollNoNameFee
1Sameed10,000
2Shahzeb10,000
3Basit0.00

Query show the resultant table: student


Example 2:

Query on table 1: SELECT RollNo, Name FROM student;

Result:

RollNoName
1Sameed
2Shahzeb
3Basit

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

 

Subscribe for Friendship

Prof. Fazal Rehman Shamil
Latest posts by Prof. Fazal Rehman Shamil (see all)

    Buy advertisement space on T4Tutorials

    For more details email [email protected]