SELECT DISTINCT [RefNId]
,[NType]
-- ,[RoleId]
-- ,[DeptId]
-- ,[CourseId]
-- ,[UserId]
,[NotificationH]
,[NotificationB]
,[Comment]
,[Status]
,[ApproveBy]
,[CreatedBy]
,[CreatedOn]
,[ModifiedBy]
,[ModifiedOn]
,[ReadTag]
FROM [dbo].[Notification] N INNER JOIN MstStage S ON N.Status=S.Id where N.DeptId=2 ORDER By N.[CreatedOn] desc