* 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
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