|
|
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
>
>
Navigation:
[Reply to this message]
|