Home Forums SQL Server 2005 T-SQL (SS2K5) Data Grouping RE: Data Grouping
ColdCoffee
SSC-Dedicated
Points: 39971
More actions
October 1, 2011 at 9:07 pm
#1389177
How about this Jeff ???
; WITH cte AS
(
SELECT *
,RowNum = ROW_NUMBER() OVER( PARTITION BY eid ORDER BY eno )
,GrpCnt = COUNT(*) OVER( PARTITION BY eid )
FROM emp
)
SELECT eno , eid
FROM cte
WHERE RowNum <= 2 AND GrpCnt > 2