Re: numbers of similar rows

2002-11-29 Thread Roger Baklund
* Urmas Buhvestov > I have MySQL database with data like > name points > a20 > b20 > c19 > d18 > e18 use test; create table MyTable (name char(1), points int); insert into MyTable values ('a',20),('b',20),('c',19),('d',18),('e',18); > is it possible to get with mysql commands

numbers of similar rows

2002-11-28 Thread Urmas Buhvestov
Hello! I have MySQL database with data like name points a20 b20 c19 d18 e18 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 first column shows how many persons have beter points +1 se