Distinct Snippets

17 December, 2011   

In a table, some of the columns may contain duplicate values. Sometimes you will need to list only the different (distinct) values in a table. The DISTINCT keyword can be used to return only distinct (different) values.

30 September, 2012   

This query will show you how to select only distinct (unique) entries from a database

23 March, 2016   

Get contents of table where the item does NOT exist in another table.

Oracle PL/SQL example for avoiding overlapping months and years