select a.id as 'ID', a.postid as 'POSTID', score from (se...

0

Please login or register to vote for this query.

(click on this box to dismiss)

Amateur Radio

Q&A for amateur radio enthusiasts

select a.id as 'ID', a.postid as 'POSTID', score from 
(select id, postid, score, 
row_number() over(order by score desc) as rnum from comments) as a 
where rnum = 1;

Enter Parameters

Options:
Switch sites:
loading Hold tight while we fetch your results