>>CREATE CURSOR junk(id n(3),qty n(5)) >> >>INSERT INTO junk values(1,500) >>INSERT INTO junk values(2,600) >>INSERT INTO junk values(3,700) >>INSERT INTO junk values(4,700) >>INSERT INTO junk values(5,700) >>INSERT INTO junk values(6,700) >>INSERT INTO junk values(7,700) >>INSERT INTO junk values(8,700) >>INSERT INTO junk values(9,700) >>INSERT INTO junk values(10,800) >>INSERT INTO junk values(11,900) >>INSERT INTO junk values(12,1000) >>INSERT INTO junk values(13,1100) >>INSERT INTO junk values(14,1200) >>INSERT INTO junk values(15,1300) >>INSERT INTO junk values(16,1300) >>INSERT INTO junk values(17,1300) >>INSERT INTO junk values(18,1400) >>INSERT INTO junk values(19,1300) >>INSERT INTO junk values(20,1300) >>INSERT INTO junk values(21,1400) >>BROWSE >>>>
>CREATE CURSOR junk(id n(3),qty n(5)) > >INSERT INTO junk values(1,500) >INSERT INTO junk values(2,600) >INSERT INTO junk values(3,700) >INSERT INTO junk values(4,700) >INSERT INTO junk values(5,700) >INSERT INTO junk values(6,700) >INSERT INTO junk values(7,700) >INSERT INTO junk values(8,700) >INSERT INTO junk values(9,700) >INSERT INTO junk values(10,800) >INSERT INTO junk values(11,900) >INSERT INTO junk values(12,1000) >INSERT INTO junk values(13,1100) >INSERT INTO junk values(14,1200) >INSERT INTO junk values(15,1300) >INSERT INTO junk values(16,1300) >INSERT INTO junk values(17,1300) >INSERT INTO junk values(18,1400) >INSERT INTO junk values(19,1300) >INSERT INTO junk values(20,1300) > > >SELECT TOP 1 Junk.*; >FROM Junk; >INNER JOIN (SELECT TOP 1 *, Qty * Cnt AS OrdBy ; > FROM (SELECT Qty, COUNT(*) AS Cnt FROM junk GROUP BY Qty) aaa; > ORDER BY OrdBy DESC) jnk ON jnk.Qty = junk.Qty; >ORDER BY Id >I would not be sure if Qty * Cnt AS OrdBy is correct. It works in this case, but may not always be correct?