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