[Subject Prev][Subject Next][Thread Prev][Thread Next][Subject Index][Thread Index]
Query Problems
- To: <linux-india-programmers@xxxxxxxxxxxxxxxxxxxxx>
- Subject: Query Problems
- From: "Krishna Srinivasan" <krishna@xxxxxxxxxxxxxxxxxxxx>
- Date: Thu, 5 Apr 2001 16:08:31 -0700
- Organization: Multimedia Studio Ltd.
- References: <Pine.LNX.4.04.10103291052020.25296-100000@phoenix.pune.gsslco.co.in> <005a01c0b886$47209520$0d01a8c0@krishna> <20010329115658.A8399@bombay.retortsoft.com> <00aa01c0b88d$27865b30$0d01a8c0@krishna>
Hi All,
I have this table which stores all the requests made for a product along
with the requester's ID.
At the end of the day I would like to determine the most requested products.
How can I query this
database and retrievethe most request products in descending order without
using any temporary
table.
Regards,
Krishna