Latest Activity


dense rank

get the 5TH highest annualincome

Rownum() Over & Rank() Over order by


Create a rank in a view

Hi, I have a view created from delimited file with fields bd, date, count and i need create a rank by bd and date. I try ROWNUMBER() OVER ( PARTITION BY ORDER BY _ ) and RANK() OVER ( PARTITION BY ORDER BY ) but it´s nos work. I try case bd when 1 th...

Rownum() Over & Rank() Over