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


:-)
I don't know HOW Muhammad defines which records he wants :-)