Hello!

<pre>
I have MySQL database with data like
name points
a    20
b    20
c    19
d    18
e    18

is it possible to get with mysql commands ONLY outpt

place repeatings name points
1  2  a 20
1  2  b 20
3  1  c 19
4  2  d 18
4  2  e 18 

</pre>
first column shows how many persons have beter points +1
second column shows how many records have same number of points



---
Urmas Buhvestov
e-mail: [EMAIL PROTECTED]      WWW: http://www.tamme.tartu.ee/~urmas/



---------------------------------------------------------------------
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/           (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Reply via email to