PostgreSQL

SELECT * FORM tablo_adi WHERE kolon1 IN ('deger1','deger2',...);
SELECT * FORM tablo_adi WHERE kolon1 IN ('deger1','deger2',...) ORDER BY kolon1 ASC ORDER BY kolon2 ASC

SELECT DISTINCT ON (kolon1,kolon2) kolon1,kolon2,... from tablo_adi
SELECT DISTINCT ON (kolon1) * from tablo_adi

SELECT kolon1,COUNT(*) as isim FROM tablo_adi GROUP BY kolon1 HAVING COUNT(*)>deger ORDER BY COUNT(*)