Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 9026 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 is difference between order by and group by?
What is the use of sign function?
What does nvl stand for?
how many bits ip address consist of? : Sql server database administration
What are clustered and non-clustered index?
Can we update data in a view?
What is a db view?
What is an execution plan? When would you use it?
I applied Transactional with updatable subscriptions replication on 2 tables now i want to delete those 2 tables but i cannot delete those tables as replication is running how can i stop replication for those 2 tables(but i don't want to delete those replicated tables but i need to stop the replication) how can i do that
Why and when do stored procedure recompile?
How to create a local temporary stored procedure?
What are “lost updates”?
Can you get second highest salary from the table?
What is the difference between varchar and varchar(max) datatypes?
How would you use user_constraints table in DB?
