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