by Behlul
29. December 2009 05:45
SELECT *
FROM(
SELECT *,
ROW_NUMBER() OVER (PARTITION BY TestMasterID ORDER BY TestMasterID desc ) as pos
FROM TestDetay
)as Detay INNER JOIN TestMaster as Master on Master.TestMasterID=Detay.TestMasterID
Where Detay.pos >2