SQL Distinct statement in database systems

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

What is SELECT DISTINCT statement?

It shows common values only one time from the given table.

RollNo Name Fee
1 Sameed 10,000
2 Shahzeb 20,000
3 Sameed 10,000

Table 1: student

Example 1:

Query on table 1: SELECT DISTINCT Name FROM student;

Result:

Name
Sameed
Shahzeb

Query show the resultant table: student

 

 

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