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?
- 7 Answers
- 7583 Views
- I also Faced
- E-Mail Answers
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
What are the grouping functions?
What are the differences between web role and worker role?
Which trace flags are enabled in sql server?
What is apply operator in sql?
Explain about unique identifier data type in sql server?
What is checkpoint process in the sql server?
What is the difference between for xml raw and for xml auto?
How to generate create view script on an existing view?
Explain what is the use of custom fields in report?
How to compare the top two records using sql?
How to change parameter value inside the report?
How to change the name of a database user?
Are connections to sql server encrypted?
What is the Main Difference between ACCESS and SQL SERVER?
what are user defined datatypes and when you should go for them? : Sql server database administration
