How can I calculate rank based on highest points and lowest time in SQL server -
I searched and searched but they are unable to work. I really appreciate it if someone helped me Can do. I have a table that stores information for the game played (small quiz application.) I should be able to determine the top 5 ranks, but having the highest score, the shortest time after. (Many players have a maximum score) I need to rank users at any time. Here is a sample of Game Table: Pre-user_id Credit Time-Playing Surname ------- --- ---- -------- --- -------------- 64 490 180 Daplaya 93 690 187 Superman 64 336 187 Dailaya 75 1962 192 Layer 93 182 197 Superman 57 844 198 John Smith 75 350 198 Layer 64 858 384 Daplaya 73 858 400 littleguy 57 858 412 John Smith 101 858 420 Flash 73 858 423 littleguy 73 858 434 littleguy 65 858 460 Sheena 122 858 540 Chinese Queen 126 858 545 Rachel 176 350 2417 Fire Light 157 350 2442 Big Q161 350 2456 JOI Blue I am using an existing query: up to 5 aliases, user_id, rank () Select (Max's) Credits, as a rank of the game in the o...