select name of emplyoee whose total salary is 130 from
following table.
id name salary
1 a 100
2 b 20
3 c 50
1 a 30
2 b 70
Post the resulantant Query?
Answer Posted / vikas kant
select emp_name, sum(salary)
from emp
group by emp_name
having sum(salary)=130
Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
Explain few examples of stored procedure over triggers?
What is updatable resultset?
What to perform pattern match with the like operator?
tell me what are the steps you will take to improve performance of a poor performing query? : Sql server database administration
Explain what are partitioned views and distributed partitioned views?
Why variables called the most powerful component of ssis?
Can we use where and having clause together?
List the different types of joins?
Which autogrowth database setting is good?
what is a deadlock? : Sql server database administration
Explain how you can deploy an SSRS report?
Why people hate cursor?
How can we remove orphan records from a table?
What to check if a User database is locked?
How to use old values to define new values in update statements in ms sql server?