Posted by Stefan Rybacki on 06/27/05 15:28

Oli Filth wrote:
> 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.
>

Yes of course, sorry.

[Back to original message]