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