Rank function in Servoy

Classic Servoy
1

Has anybody build a rank function in Servoy?

I need to build in Servoy the same rank function that it’s found in Excel.

Any clues in this regard will be more than appreciated!

2

Servoy doesn’t have a rank function but the bundled database (PostgreSQL) does.
The syntax looks like this:

SELECT id,num,rank FROM (
  SELECT id,num,rank() OVER (ORDER BY num) FROM foo
) AS bar WHERE id=2

For more information check out the excellent PostgreSQL documentation:
http://www.postgresql.org/docs/8.4/stat … indow.html
http://www.postgresql.org/docs/8.4/stat … -FUNCTIONS

You find these window functions in other brands of databases as well (MSSQL/Oracle/etc., not MySQL though)

Hope this helps.

3

Rob, thanks a bunch!