Eine etwas komplexere Sortierung

[alzaimar]

Aha, pro Eintrag in Feld1...Feld5 eine Zeile im Resultat.

SQL-Code:

select * from tabelle where feld1 is not null
union
select * from tabelle where feld2 is not null
union
select * from tabelle where feld3 is not null
union
select * from tabelle where feld4 is not null
union
select * from tabelle where feld5 is not null
order by coalesce (feld1,feld2,feld3,feld4,feld5)