SQLite Forum

Show duplicate rows sorted

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?