>Sir,
>
>While Using Sqlserver 2012, I have this data
>
>

>CREATE CURSOR Table1(id n(3),qty n(5))
>
>INSERT INTO Table1 values(1,1500)
>INSERT INTO Table1 values(2,1600)
>INSERT INTO Table1 values(3,1700)
>INSERT INTO Table1 values(4,1700)
>INSERT INTO Table1 values(5,1700)
>INSERT INTO Table1 values(6,1700)
>INSERT INTO Table1 values(7,1700)
>INSERT INTO Table1 values(8,1700)
>INSERT INTO Table1 values(9,1700)
>INSERT INTO Table1 values(10,1800)
>INSERT INTO Table1 values(11,1900)
>INSERT INTO Table1 values(12,2000)
>INSERT INTO Table1 values(13,2100)
>INSERT INTO Table1 values(14,2200)
>INSERT INTO Table1 values(15,2300)
>INSERT INTO Table1 values(16,2300)
>INSERT INTO Table1 values(17,2300)
>INSERT INTO Table1 values(18,2400)
>INSERT INTO Table1 values(19,2300)
>INSERT INTO Table1 values(20,2300)
>INSERT INTO Table1 values(21,2500)
>INSERT INTO Table1 values(22,2500)
>INSERT INTO Table1 values(23,2500)
>INSERT INTO Table1 values(24,2500)
>INSERT INTO Table1 values(25,2600)
>INSERT INTO Table1 values(26,2700)
>
>COPY TO d:\last5max.xls TYPE xl5
>

>
>
>Data look likes this
>
>
>
>I want to get this value
>
>id qty
>22 2500
>
>while using this technique:
>
>1-Want to get result from only last 5 records
>2-The heigher qty that is used maximum time
>

How do you know which are the last 5 records? Are they the ones with the highest IDs?

On #2, are you saying that if more the one value has the greatest count, you want the largest value among those?

Tamar