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

0

Please login or register to vote for this query.

(click on this box to dismiss)

Drones and Model Aircraft

Q&A for experienced flyers, pilots, and builders of drones and model aircraft

select a.id 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

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