|
|
Posted by Oli Filth on 06/27/05 14:34
Stefan Rybacki said the following on 27/06/2005 10:56:
> Jim S. wrote:
>
>> hi guys,
>> I have a table that am calculating number of clicks in it, how can i
>> make a
>> query that will give me the top 3 (or what ever number, 4, or 5 ...) my
>> brain at this moment 4:00 AM does not seem to want to help me out, so
>> please
>> help.
>> thanks
>> Jim
>
>
> Which RDBMS are you using?
>
> mySQL knows LIMIT
>
> SELECT clicks FROM clicktable ORDER BY clicks DESC LIMIT 1,3
>
That should be:
LIMIT 0, 3
or:
LIMIT 3
Row-numbering starts from 0.
--
Oli
Navigation:
[Reply to this message]
|