SQL Select statement in database systems

By Prof. Fazal Rehman Shamil
Last modified on May 27th, 2019

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

 

Prof.Fazal Rehman Shamil (Available for Professional Discussions)
1. Message on Facebook page for discussions,
2. Video lectures on Youtube
3. Email is only for Advertisement/business enquiries.