select sum of salary >50000 between month of jan to dec for

Anjali Khan

9y827

hi frnds

pasting

write query in linq and sql for select sum of salary >50000 between month of jan to dec for employee with desending order.

4 Replies

Know the answer? Post it — somebody with the same question will find it here.

Nitin Sontakke9y ago
Accepted answer
Why not post a separate question? If you accept the answer, I get the points. Anyway!

1/ If the joins are not used remove these.

2/ Do not perform group by + order by in a single select. Typically it is advisable that you perform simple select with only where clause and store result in temp table. Then perform aggregate (that is group by) and order by on that.

3/ If possible and appropriate use view instead.

4/ Ensure you have PK or index on all columns involved in where clause and join clause.
+1

Anjali Khan9y ago

Situation based question: I have a SQL stored procedure which returns 100000 records and each record have 50 fields. This Stored procedure returns product items on the grouping by the categories. Now I am using SELCT * command with ORDER BY clause and have some LEFT and RIGHT JOINS which is not used either in select command and WHERE clause. How can you improve the performance of Stored Procedure? Is there any other approach to provide solution?

Anjali Khan9y ago
hi Nitin

thanks for the update
0
Nitin Sontakke9y ago
select employeeId, totalSalary
from
(
select employeeId
,sum(salary) totalSalary
from employeeSalary
where salary > 50000
and month(paidDate) between 1 and 12
group by employeeId
) es
order by totalSalary desc

I don't know LINQ. Is this yet another interview question?
+1