Jim S. wrote:
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
Do you want a SQL solution or a PHP one?
SQL: have a look at aggregat functions for Strings like SUBSTRING