SQL Distinct statement in database systems

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;



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.