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 (Available for Professional Discussions)
1. Message on Facebook page for discussions,
2. Video lectures on Youtube
3. Email is only for Advertisement/business enquiries.