How to get rank

2010-10-02 Thread shareproduct
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.

Re: How to get rank

2010-10-02 Thread shareproduct
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

Re: How to get rank

2010-10-02 Thread David Brown
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

Re: How to get rank

2010-10-02 Thread Kerry Sainsbury
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