Posted by Stefan Rybacki on 06/27/05 12: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


SQLServer for example has the TOP keyword

SELECT TOP 3 clicks FROM clicktable ORDER BY clicks DESC


>
> if u feel like it, maybe u can help with the next question (am doing a
> different post for it too)
> i did this before, but i forgot what i used,
> anyhow, i have a field that maybe 255 characters, i want to display only
> 100, how can i do that?
> thanks again
> Jim

Do you want a SQL solution or a PHP one?

SQL: have a look at aggregat functions for Strings like SUBSTRING
$text100=PHP substr($text,0,100);


Regards
Stefan
>
>

[Back to original message]