dik moc, po par upravach to dela presne to co chci
SELECT @i:=0;
SELECT i FROM (
SELECT @i:=@i+1 AS i, id FROM (
SELECT t.* FROM tab AS t WHERE a=2 AND b=3 AND c=3 ORDER BY sloupec5 DESC, sloupec3 DESC
)AS temp1
)AS temp5 WHERE id=X
poradna.net
Neregistrovaný Přihlásit Registrovat