hi to all,
i m making a raking star module, there was a field total_vote that increases when ever anyone make ranking,,, i want to get 10..or 20 whatever strength....that will have maximum values...please tell me the SELECT query to select that field's top 20 records...
thanks in advance
how to get max 10 records from table
Moderator: General Moderators
-
mianmajidali
- Forum Commoner
- Posts: 30
- Joined: Tue Dec 01, 2009 8:05 pm
Re: how to get max 10 records from table
you can use the ORDER and LIMIT clauses to do that