Distinct Top Records From Table

[heminfotech]

Hi


Please help me on this its URGENT.....


I have one Table from which I want Distinct Top Records. Means I need the such records in which there should be only one user with highest no of votes of particular round

ROUND 1
User | Votes | ENTRY(PK)
1 20 1
2 25 2
1 35 3
2 45 4
3 55 5
1 75 6

The Output should be something like this.

User | Votes | Entry
1 75 6
3 55 5
2 45 4


Please can any one help me on this I had tried a lot but I didn't get the result

[amitpatel66]

Hi


Please help me on this its URGENT.....


I have one Table from which I want Distinct Top Records. Means I need the such records in which there should be only one user with highest no of votes of particular round

ROUND 1
User | Votes | ENTRY(PK)
1 20 1
2 25 2
1 35 3
2 45 4
3 55 5
1 75 6

The Output should be something like this.

User | Votes | Entry
1 75 6
3 55 5
2 45 4


Please can any one help me on this I had tried a lot but I didn't get the result

Could you please post your query for my reference what you have tried?

[mwasif]

The following query will list down the users with highest votes on top.

SELECT * FROM table ORDER BY Votes DESC

What do you mean by ROUND?

[amitpatel66]

Try this:

 
select r.entry,g.user,g.mvotes FROM
(select user,max(votes) mvotes rom table_name group by user) g,table_name r
WHERE r.user = g.user
AND r.votes = g.mvotes