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



Fazal Rehman Shamil
Welcome to all friends. The reason for our success is only your love for T4Tutorials. Our team is always available to answer your queries regarding any kind of confusions or discussion regarding your study and career matters. For discussion with us please join our facebook group "T4Tutorials.com". The link of the group is mentioned below. Thanks and love to all for connecting with us. We are nothing without you. Love you all.....

Leave a Reply