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 / anonymous
select name as Sal
from emplyoee
group by id
having sum(salary)=130
Is This Answer Correct ? | 3 Yes | 1 No |
Post New Answer View All Answers
Do you know what is fill factor and pad index?
Difference between group by clause and having clause in SQL?
What is the architecture of ms sql reporting service?
Tell me something about security and sql azure?
What is forward - only cursors / read only cursor?
How we can refresh the view?
You want to check the syntax of a complicated update sql statement without executing it. What command should you use?
what are the reporting service components in SSRS?
List out the differences between global and local temp tables in sql server?
when you create a database how is it stored? : Sql server database administration
State a few properties of relational databases?
What are different types of schemas?
What is pessimistic concurrency?
What are rows and columns?
What is cached report?