Hello Friends,
In my database, I have a colum Salary with numeric(18,0)
I want to write code for getting total employee salary
For example; select couunt(*) from Employee
select Department,count(*) from Employee group by Department
Here I wrote;
- var count = db.Employees.Count(x => Convert.ToBoolean(x.Salary));
But,Im getting error. please help me to solve
Mansi GuptaPosted May 18, 2016, 6:20 AM
ali tuncerPosted May 17, 2016, 12:20 AM
select Department,count(*) from Employee will give you total employee number, not sum of salary..