SQL Distinct statement in database systems

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

 

 

Subscribe for Friendship

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

    Buy advertisement space on T4Tutorials

    For more details email [email protected]