Re: How to define TOP 5 records?

[Felix Geerinckx]

Sergei wrote:

> For example, we have some records of votings for users:
> ...
> -- but I suppose that the right result should be
> ...
> -- cause we have users with the same votings
>
> What should I do to find out the solving.

You need a temporary table:

DROP TABLE IF EXISTS temp_ttt;
CREATE TEMPORARY TABLE temp_ttt SELECT vote FROM ttt ORDER BY vote DESC LIMIT 5;
SELECT ttt.uid, ttt.uname Best, ttt.vote
FROM ttt
JOIN temp_ttt ON temp_ttt.vote = ttt.vote
ORDER BY ttt.vote DESC;

--
felix
Please use BBCode to format your messages in this forum.