...分组下的第一条数据,如下图:我想取1,4的数据,我该如何写SQL呢...答:SQLSERVER语句如下: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...