Hello,
what's the fastest way to get rank of of row from a table with 20
000+ rows?
can someone please post a sql script
Thanks
--
You received this message because you are subscribed to the Google Groups H2
Database group.
To post to this group, send email to h2-datab...@googlegroups.com.
Assume I've a table game:
id---PlayerName---Score
1joe 1500
1jack 1100
1john 900
1steve 100
1bob 1000
the rank of joe will be 1, bob 3 ...
On Oct 2, 1:08 pm, Kerry Sainsbury ke...@fidelma.com
On Sat, Oct 02, 2010 at 09:27:39AM -0700, shareproduct wrote:
what's the fastest way to get rank of of row from a table with 20
000+ rows?
can someone please post a sql script
I haven't tried to see how efficient this will be, and it won't
distinguish among elements where the sort field has
You want to sort by score desc, and use 'rownum'
http://www.h2database.com/html/functions.html?highlight=rownumsearch=row#rownum
http://www.h2database.com/html/functions.html?highlight=rownumsearch=row#rownum
Cheers
Kerry
On Sun, Oct 3, 2010 at 6:13 AM, shareproduct soufi.kha...@gmail.com