Hello, I am selecting duplicates in the "name" column of a table called "Records" using this query. select * from Records tab_a join (select name from Records group by name having count(name) > 1) tab_b on tab_a.name = tab_b.name The problem with this query is that it won't give me the rows sorted by "name" - which is what I want -, and I can't use a simple ORDER BY because the "name" column can contain unicode characters. Is it possible to achieve this in pure SQL? Thanks!