forum.lissyara.su

Код: Выделить всё

id | name | pole|
------------------|
1	a	   20
2	b	   30	|
3	c	   10
----------------- |

Код: Выделить всё

SELECT count(*)+1 FROM `table` AS t1
LEFT JOIN `table` AS t2
ON t1.id=$id AND t1.pole < t2.pole
where t2.id IS NOT NULL

Код: Выделить всё

select id from table order by pole desc limit 1;

Код: Выделить всё

SELECT count(*)+1 FROM `table` AS t1
LEFT JOIN `table` AS t2
ON t1.id=$id AND t1.pole < t2.pole
where t2.id IS NOT NULL

Код: Выделить всё

select tmp.position
from (select row_number() over(order by pole desc) as position, id from rating) as tmp
where tmp.id = 2