SQL Distinct statement in database systems

Last modified on August 28th, 2018 at 1:21 pm

What is SELECT DISTINCT statement?

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

RollNoNameFee
1Sameed10,000
2Shahzeb20,000
3Sameed10,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
Researcher, Publisher of International Journal Of Software Technology & Science ISSN: 2616-5325
Instructor, SEO Expert, Web Programmer and poet.
Feel free to contact.