-- 1
SELECT
	b.*
FROM
	YourTable a
	CROSS APPLY
	(
		SELECT TOP 1 *
		FROM YourTable b
		WHERE b.Catid = a.CatId
		ORDER BY col1,col2 -- columns you want to use to determine which one to pick
	) b

-- 2	
SELECT
	a.Col1,
	a.Col2,
	a.CatID
FROM
(
	SELECT b.*,
	ROW_NUMBER() OVER 
	(
		PARTITION BY b.catid
		ORDER BY col1, col2 -- columns you want to use to determine which one to pick
	) RN
	FROM YourTable b
) a
WHERE a.RN = 1;

quote:

---

Originally posted by visakh16

first determine rule or retrieval of top 1. what are columns based on which you want to determine the top 1?

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/

---

select b.*
  from (select catid
              ,max(addeddate) as addeddate
          from tablename
         group by catid
       ) as a
  inner join tablename as b
          on b.catid=a.catid
         and b.addeddate=a.addeddate

SELECT CatID, other columns...
FROM
(
	SELECT *,
	MAX(addeddate) OVER (PARTITION BY catid) AS MaxDate
	FROM YourTable b
) a
WHERE addeddate = MaxDate;