Monday, October 10, 2016

What is distinct in SQL?

The key called distinct use for bring the value who are different not same. In a table there lots of duplicates data. There some situation we need to select list of  different value .

Table 

User Table

Distinct query:

Select DISTINCT Name from Users

Following this query output will come distinct value.

Result:

 

No comments:

Post a Comment