Postgresql examples

examples.sql

# Grouping, case insensitive
SELECT lower("subjects"."name_last"), lower("subjects"."name_first"), lower("subjects"."history") FROM "subjects" GROUP BY lower(subjects.name_last), lower(name_first), lower(history) HAVING count(*) > 1;

# Another way
select name_last, name_first, history 
from subjects 
where (upper(name_last), upper(name_first), upper(history)) in 
  (select upper(name_last), upper(name_first), upper(history) 
  from subjects 
  group by upper(name_last), upper(name_first), upper(history) 
  having count(*) > 1) 
order by name_last;