DISTINCT « Select Query « Oracle PL / SQL






  1. Oracle PL / SQL
  2. Select Query
  3. DISTINCT
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