[prog] newbie SQL query assistance needed

Tina tyamar at gmail.com
Tue Apr 27 19:54:39 UTC 2010


I have an orders table. In it are all the orders (orderid) with each item
ordered (itemid) and quantity (quantity).

I need to figure out which item was ordered the most times. I know it
involves a multi-row query, but I just can't seem to figure it out.

Thanks in advance,

Tina


More information about the Programming mailing list