select and select distinct in db2 database

select distinct on one column

select distinct multiple columns

select distinct on one column with multiple columns returned

difference between select and select distinct

select distinct count