Skip to Content
0
Former Member
May 31, 2008 at 03:48 AM

DENSE_RANK()

407 Views

Hi,

Do yo know the meaning of the following queries?

Select

convert(integer, DENSE_RANK() OVER (ORDER BY TransId))

convert(integer, NTILE(@ABC) over (PARTITION BY TransId order by TransId))

0.00 as 'LineNum'

from jdt1

Select

convert(integer, ROW_NUMBER() OVER (ORDER BY TransId))

" as 'JdtNum'

from ojdt

I couldn't find "DENSE_RANK", "NTILE", "ROW_NUMBER", "0.00", " in the field name.

What is the meaning of "over" and "Partitiion by"?

Thanks.

Raymond