Welcome to the Monastery | |
PerlMonks |
Limit results of a DBI queryby peppiv (Curate) |
on Jan 28, 2003 at 16:23 UTC ( [id://230635]=perlquestion: print w/replies, xml ) | 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. TIA peppiv
Back to
Seekers of Perl Wisdom
|
|