110,536
社区成员
发帖
与我相关
我的任务
分享
select
EmployeeCode,
count(EmployeeCode) [nn]
from employeeMsg
group by EmployeeCode
having count(EmployeeCode) > 1
var q =
from p in dt.AsDataView()
group p by p.EmployeeCode into g
select new
{
g.EmployeeCode,
Num = g.Count()
};
var query = from DataRow r in dt.Rows
let employee = (string)r["EmployeeCode"]
group r by employee into g
where g.Count() > 1
select new { EmployeeCode = g.Key, Count = g.Count() };
var q = from p in dt.AsEnumerable()
group p by p.Field<string>("EmployeeCode")
where p.Field<string>("EmployeeCode").Count()>1
select new
{
EmployeeCode = p.Field<string>("EmployeeCode"),
CountNumber = p.Field<string>("EmployeeCode").Count()
};
var q =from p in dt.AsEnumerable()
where p.Field<int>("EmployeeCode").Count()>1
select new
{
EmployeeCode = p.Field<string>("EmployeeCode"),
CountNumber = p.Field<int>("EmployeeCode").Count()
};
var q =
(from p in dt.Rows.Cast<DataRow>()
group p by p["EmployeeCode"].ToString() into g
select new
{
Code = g.Key,
Num = g.Count()
}).Where(x => x.Num > 1);
var q =
from p in dt.Rows.Cast<DataRow>()
group p by p["EmployeeCode"].ToString() into g
select new
{
Code = g.Key,
Num = g.Count()
};
var q =
from p in dt.Rows
group p by p["EmployeeCode"].ToString() into g
select new
{
Code = g.Key,
Num = g.Count()
};