Hi Harshana,There is no function available with SQL Server similar to ''LIMIT'' but you can get the result set as you want.Here is one the ways of limiting records with SQL Server 2000. SELECT  T.*FROM(    SELECT TOP 100 PERCENT (SELECT COUNT(*) FROM Person.Contact WHERE ContactID <= c.ContactID) AS RowNumbr, ...