Limit results of a DBI queryby peppiv (Curate)
|on Jan 28, 2003 at 16:23 UTC||Need Help??|
peppiv has asked for the
wisdom of the Perl Monks concerning the following question:
Good day y'all!
I need to limit the results of a DBI query. But here's the catch. I'm querying a SQL Server DB which does not use the LIMIT command commonly found in MySQL. Oh, if it could be that easy.
Here's the basic structure:
I get the return of the country and the count. But it returns all rows and I only need the first 10 - in order of descending count value.
Any help would be greatly appreciated.
I tried to put together a for statement with a count in it but that was a disaster.