Помогите написать sql-запрос

[Tonal]

Firebird 2.x берёт такое:

Код

SQL
SELECT TB.CODE, TB.NAME
FROM TB
INNER JOIN (
  SELECT CODE, min(NAME) FROM TB GROUP BY CODE) GR ON GR.CODE = TB.CODE
ORDER BY GR.NAME, TB.NAME