SQL Server extracts the first few entries in each group after grouping

Table: T
Field: Id auto increment,
Field1 number,
.....
Select * From (
Select * ,( Select Count ( * ) From T As T2 Where T2.field1 = T1.field1 And T2.id <= T1.id) As Aaa From T As T1) As T3
Where Aaa <= 2

T2.field1 = t1.field1 is a condition for grouping and can be freely added.

Reference address:

Http://topic.csdn.net/t/20040819/17/3291042.html

 

 

Extract the first five data entries of each category.

 

Select ID, title, d_picture, addtime, newstypeid, JJ, content
From News NS
Where ID In ( Select Top 5 ID From News Where Newstypeid = NS. newstypeid And Isactive = ' 1 ' Order By Addtime Desc )