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


Please login or register to vote for this query.

(click on this box to dismiss)

Amateur Radio

Q&A for amateur radio enthusiasts

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

Enter Parameters

Switch sites:
loading Hold tight while we fetch your results