Help with Generating top 10 table
Posted: Thu May 18, 2006 4:33 pm
Hi to all,
I have a users table where users have rating in the form of "9.43" for example. How can i create a routine or a procedure that will populate a "topten" table with current 10 top users.
for the reference, database name is "TESTBASE", user database is "users" and rating filed is "rating" and i want to populate a table "topten"
with fields "username","rating","completed posts" and "logo"
I know it might take a few beers to figure this out so i will paypal the money for 6 pack to the person that helps me as a thanks!
I have a users table where users have rating in the form of "9.43" for example. How can i create a routine or a procedure that will populate a "topten" table with current 10 top users.
for the reference, database name is "TESTBASE", user database is "users" and rating filed is "rating" and i want to populate a table "topten"
with fields "username","rating","completed posts" and "logo"
I know it might take a few beers to figure this out so i will paypal the money for 6 pack to the person that helps me as a thanks!