In case you missed the announcement: The Alteryx One Fall Release is here! Learn more about the new features and capabilities here
Start Free Trial

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
Top Solution Authors