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