How to limit the SQL query result set to Top-N rows only

#SQL:
SELECT
title
FROM
post
ORDER BY
id DESC
FETCH FIRST 5 ROWS ONLY

#PostgreSQL 8.3 and #MySQL:
SELECT
title
FROM
post
ORDER BY
id DESC
LIMIT 5

#Oracle 11g and older versions:
SELECT *
FROM (
SELECT
title
FROM
post
ORDER BY
id DESC
)
WHERE ROWNUM <= 5


@javaCode☕️