你想统计什么? 字段2相同,字段3不同? 我是没怎么看明白 select count(distinct 字段2,字段3) from TABLE1
楼主是这个意思不? SELECT count(*) from (select 字段1,字段2+字段3 as 临时字段,字段4 from [表名]) WHERE 字段1 in (Select Max(字段1) from (select 字段1,字段2+字段3 as 临时字段,字段4 from [表名]) Group by 临时字段) SQL code:
select sum(case when 字段2 = 字段3 then 1 else 0) as aa sum(case when 字段2 = 字段3 then 0 else 1) as bb from tb
using System; using System.Collections.Generic; using System.Linq; using System.Web; using System.Web.UI; using System.Web.UI.WebControls; using System.Runtime.InteropServices; nam ......