You are viewing a single comment's thread from:

RE: In grouping nested query, the clause for ordering is invalid.

in #utopian-io7 years ago (edited)

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]