>>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 am not sure that is the logic but who knows.
Select top 1 junk.* from junk ; inner join ; (Select top 1 Qty, Sum(Qty) from junk group by 1 order by 2 desc) tmp on junk.Qty = tmp.Qty ; order by idPS: I wonder why people name their cursors "junk" :)