Untitled

From Violet Horse, 4 Months ago, written in Plain Text, viewed 64 times.

URL http://codebin.org/view/4c4fa92d Embed

Download Paste or View Raw

with tb1 as (select b.user_id, count(b.id) as num
from stackoverflow.badges b 
where b.creation_date between '15.11.2008' and '15.12.2008'
group by b.user_id
order by num desc
limit 10)
select *, dense_rank() over(order by num desc)
from tb1

Reply to "Untitled"

Here you can reply to the paste above

Author What's your name?

Title Give your paste a title.

Language What language is your paste written in?

Your paste Paste your paste here

Create Shorturl Create a shorter url that redirects to your paste?

Private Private paste aren't shown in recent listings.

Delete After When should we delete your paste?