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
- 7607 Views
- I also Faced
- E-Mail Answers
Answer Posted / kuntal bhattacharya
select name from
(select name ,sum(salary) as Sal from emplyoee
group by id ,name)as s
where Sal=130
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
What is the difference between for xml raw and for xml auto?
Why does a sql statement work correctly outside of a user-defined function, but incorrectly inside it?
How to update a field in SQL after ALTERING a row?
What is the difference between coalesce() & isnull()?
What is the Difference Between Primary and Foreign Key?
How do you create a data source?
What is the use of @@spid?
What kind of problems occurs if we do not implement proper locking strategy?
What are four major operators that can be used to combine conditions on a where clause?
what is a self join? : Sql server database administration
Please explain the characteristics of a transaction server for example atomicity, consistency, isolation, durability?
What is the purpose of object explorer and its features? : sql server management studio
What are different types of views?
How to check what was the last restore transaction LSN in Log shipping or Mirroring? when we don't have a Monitor or witness server.
Do you know what is recursion? Is it possible for a stored procedure to call itself or recursive stored procedure? How many levels of sp nesting is possible?
