Advent of Code is back! Unwrap daily challenges to sharpen your Alteryx skills and earn badges along the way! Learn more now.

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

In DB Ranking

Ikader
5 - Atom

Is there an example of how to do IN-DB Ranking?

2 REPLIES 2
RolandSchubert
16 - Nebula
16 - Nebula

Hi @Ikader ,

 

you could use the SQL function RANK to do IN-DB ranking. A SQL query would be similar to this (use the MS SQL Server WorldWideImporters sample database):

 

2022-03-15_18-46-59.jpg

The Rank function returns the rank of a record, it's completely done on the database server and you only have to stream out the results. 

If you explain in more detail, what you need, I can be more specific.

 

Best,

 

Roland 

Ikader
5 - Atom

Thank you

Labels