>>Sir, this is my first post in levelextreme
>>
>>I have this data
>>
>>
>>

>>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
>>

>>
>>
>>I want to get data showing with arrow.
>>
>>
>>
>>
>>Formula:
>>
>>What maximum qty is being used as maximum time?
>>
>>qty 1400 is maximum qty but is being used only 2 times
>>qty 1300 is not maximum but it is being used 5 times.
>>qty 700 is being used 7 times but it is not maximum.
>>
>>So I need a maximum qty with maximum times with its respective id like
>>
>>15, 1300
>>Both conditions : maximum qty + maximum number of occurrence
>>
>>Here is occurrence count
>>
>>
>>
>>
>>Please help me
>
>

>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?