DECLARE	@Temp TABLE
(
	Id		varchar(8),
	RegID		varchar(6),
	CreatedDate	datetime,
	ApplicationNo	varchar(6),
	statusId	int
)

INSERT INTO @Temp
SELECT	'196ec71f', '3b5b0a', '2007-06-12', 'APP_10', 1 UNION ALL
SELECT	'5f5bbfaa', '3b5b0a', '2007-06-13', 'APP_12', 0 UNION ALL
SELECT	'ced3196b', 'a2362', '2007-06-06', 'APP_05', 1 UNION ALL
SELECT	'eb80aba4', 'b1111', '2007-06-05', 'APP_06', 2 UNION ALL
SELECT	'466e-b7c', 'a2362', '2007-06-09', 'APP_03', 1 UNION ALL
SELECT	'98b7cb6e', 'c5777', '2007-05-13', 'APP_01', 3

SELECT	*
FROM	@Temp AS T1
	JOIN
	(
		SELECT	RegID,
			[MAX_CreatedDate] = MAX(CreatedDate)
		FROM	@Temp
		GROUP BY RegID
	) AS T2
		 ON T2.RegID = T1.RegID
		AND T2.MAX_CreatedDate = T1.CreatedDate

Select 	Id, RegID, CreatedDate, ApplicationNo, statusId	from
( Select *, row_number() over (partition by regid order by createddate desc) as recid from @temp
)
As d
where recid = 1