How to get First Row of Each group in a Table
By Rizwan Saqib   Posted on March-26-2018 642
MS Sql Server
WITH FirstEmployeeOf_EachDepartment
AS
(
SELECT E.Employee_ID , E.Name,E.Age , E.Department_ID,
ROW_NUMBER () OVER (PARTITION BY E.NAME ORDER BY E.Employee_ID Desc) AS RN
FROM Employee E)
SELECT F.Employee_ID,F.Name,f.Age,f.Department_ID FROM FirstEmployeeOf_EachDepartment F
Where f.RN = 1
WITH FirstEmployeeOf_EachDepartment
AS
(
SELECT E.Employee_ID , E.Name,E.Age , E.Department_ID,
ROW_NUMBER () OVER (PARTITION BY E.NAME ORDER BY E.Employee_ID Desc) AS RN
FROM Employee E)
SELECT F.Employee_ID,F.Name,f.Age,f.Department_ID FROM FirstEmployeeOf_EachDepartment F
Where f.RN = 1
By Rizwansaqib966   26-Mar-2018
Views 642
Share This with your friend by choosing any social account
You may also read following recent Post
![]() |
Types Of database
700 By Rizwan Saqib |
![]() |
History Of DataBase
716 By Rizwan Saqib |