SQL Server group take top N Records

1. Preface.

There are two ways of doing this. 1 is used in,2 is used row_number (), can be used according to the situation. Both of them are OK.

2. For example.

Method 1:

Java code

Select A.* from table1 a where a.column1 in (select Max (column1) to Table1 Group by A.column2,column3)

Method 2:

Java code

With Nyr as (

Select Nyr,qyzx_dm,fxsp_xh,spbm_dlj,wbsp_gg,jglx,jzjg,max (SJGX_SJ),

Row_number () over (partition by Nyr ORDER by Nyr) as ' Rowno '

From Wd_o_t_ic_spsj_fx

where rowno=1

GROUP BY NYR,QYZX_DM,FXSP_XH,SPBM_DLJ,WBSP_GG,JGLX,JZJG

Order by Nyr,qyzx_dm,fxsp_xh,spbm_dlj,wbsp_gg,jglx,max (SJGX_SJ) desc)

SELECT *

From Nyr

where Rowno = 1