You are viewing a single comment's thread from:
RE: In grouping nested query, the clause for ordering is invalid.
Your contribution cannot be approved because it does not follow the Utopian Rules.
Hi this is not a bug. Your correct SQL should be
SELECT * FROM (
SELECT
permlink,
TIMESTAMP,
ROW_NUMBER() OVER (PARTITION BY permlink ORDER BY timestamp DESC) as col
FROM sbds_tx_comments where author='tvb' and permlink NOT LIKE 're%' and TIMESTAMP > '2018-01-24 00:00:00' ) as x
WHERE x.col = 1
order by TIMESTAMP desc
You can contact us on Discord.
[utopian-moderator]