Sorting …

[Aly IGERY]

Hi everyone,
How can I sort the query below by "newest first" or "last modified first"?

SELECT "id","Beschreibung","Betreff","Ktgr","Info"
FROM "IGERYsNotes"
WHERE ("removed" IS NULL OR "removed" = 0)
AND COALESCE("Beschreibung",'') LIKE '%%'
AND COALESCE("Betreff",'') LIKE '%%'
AND COALESCE("Ktgr",'') LIKE '%%'
AND COALESCE("Info",'') LIKE '%%'

[Mmm]

По дате создания (обратное):

ORDER BY created_time DESC

По дате изменения (обратное):

ORDER BY updated_time DESC

вторник, 14 июля 2026 г. в 18:46:36 UTC+3, warna...@gmail.com:

[Aly IGERY]

👍 🙏