26  SQL SELECT DISTINCT

It is used for removing duplicate rows from results.

SELECT ADI FROM ORTAK.KISI;

Result:

• Atilla
• Aydın
• Atilla
• Ali
• Efe
• Duru
• Duru

SELECT DISTINCT ADI FROM ORTAK.KISI;

Result:

• Atilla
• Aydın
• Ali
• Efe
• Duru

26.1 Chinook example

select FirstName from customer;

select DISTINCT FirstName from customer;