DISTINCT « Select Query « Oracle PL / SQL






1.Remember that the DISTINCT operator applies to the entire select list
2.DISTINCT: Eliminating duplication in the result set
3.DISTINCT operator inside a group function
4.DISTINCT clause can be used with more than one field
5.Eliminating Duplicate Data Using DISTINCT
6.Eliminating Duplicate Date type Data Using DISTINCT
7.Count distinct with group by
8.DISTINCT tableName.*
9.Distinct city and state