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
- 7581 Views
- I also Faced
- E-Mail Answers
Answer Posted / mahavir bansal
select Name as Sal from emplyoee
group by Name
having sum(salary)=130
| Is This Answer Correct ? | 17 Yes | 3 No |
Post New Answer View All Answers
What are different type of Collation Sensitivity?
What new changes are being made in SQL Server?
What is a subquery in a select query statement in ms sql server?
Can another user execute your local temporary stored procedures?
What is inner join? Explain with an example?
Explain how to maintain a fill factor in existing indexes?
Can two tables share a primary key?
How do I find my localdb version?
How many replicas are maintained for each sql azure db?
What are the five major components of a dbms?
Explain what is use of dbcc commands?
Explain aggregate functions?
How many types of relations are there between dimension and measure group? : sql server analysis services, ssas
What authentication modes does sql server support?
Can truncate be rolled back?
