>CREATE CURSOR table1(id n(3),qty n(5)) > >INSERT INTO table1 values(1,500) >INSERT INTO table1 values(2,600) >INSERT INTO table1 values(3,700) >INSERT INTO table1 values(4,3500) >INSERT INTO table1 values(5,900) >INSERT INTO table1 values(6,1200) >INSERT INTO table1 values(7,1300) >INSERT INTO table1 values(8,1500) >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,2500) >INSERT INTO table1 values(14,1600) >INSERT INTO table1 values(15,1000) >>
SELECT * FROM Table1 WHERE Qty = (SELECT MAX(Qty) FROM Table1 WHERE ID IN (SELECT TOP 5 ID FROM Table1))Tamar