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
- 8767 Views
- I also Faced
- E-Mail Answers
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
What do you understand by intent locks?
Does the order of columns in update statements matter?
How do I open a .db file?
How to disable stored procedure sql server?
What is sql language?
What is the difference between the application object and session object?
You have a table ‘test’ which is a copy of northwind employee table you have written a trigger to update the field ‘hiredate’ with the current date
Explain what is the function of sql server agent windows service?
what is a self join? Explain it with an example? : Sql server database administration
What are the five characteristics of good data?
What is resultset concur_updatable?
Explain DBCC?
Do you know what is similarity and difference between truncate and delete in sql?
Tell me what are the advantages of using stored procedures?
How to use clusters?
