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