Why do you keep asking the same simple questions over and over again ?

>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
>
>Example:
>
>In the last 5 records,
>qty 2500 comes 3 times
>qty 2600 comes 1 time
>qty 2700 comes 1 time
>
>So 2500 comes most of the times
>
>Please help
>
>
>
>
>Data look likes this