Posted by toedipper on 07/13/05 01:33

Hello,

I have the folowing query.

SELECT sw.swid, title, shortdesc, version, catid, count(dl.swid),warename
FROM software sw
LEFT JOIN downloads dl ON sw.swid = dl.swid
JOIN waretypes wt ON sw.wareid = wt.wareid
WHERE liveyn = 'y'
GROUP BY
sw.swid, title, shortdesc, version, catid
limit 20


It works but it just gives me the first 20 records. I select from a
software table and then join to a downlaods table and count instances of
a software id, each instance is a downloand.

What I really want is for the 20 to show the TOP 20 downloads
(instances. I think what I am looking for is an equivalent statement to
the TOP in MS Sql.

Any ideas?


Thanks,

td.

• Next in forum: Re: mysql limit...need TOP 20 not FIRST 20 records....
• Prev in forum: Re: Mysql_fetch_col()
• Thread view: mysql limit...need TOP 20 not FIRST 20 records....

[Reply to this message]