select sum(salary) as Sal from emplyoee group by id having sum(salary)=1

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?

Question Posted / ajay kumar

7 Answers
8671 Views
I also Faced
E-Mail Answers

Answer Posted / ajay kumar

select sum(salary) as Sal from emplyoee
group by id
having sum(salary)=130

Is This Answer Correct ?

8 Yes

8 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What is co-related sub query?

1001

Explain having clause?

946

How many databases Microsoft SQL server provides?

1065

hi, the following are the outputs of sp_spaceused and sp_tempdbspace sp_spaceused ------------ database size unallocated size tempdb 77752.95 MB 28026.99 MB sp_tempdbspace ------------- database size spaceused tempdb 77752.945312 1.007812 the unused space in sp_spaceused is nearly 28 Gb and in sp_tempdbspace is nearly 76 Gb cany any one explain about this output and why its giving different results.

2910

Can you explain what are commit and rollback in sql?

917

What do you understand by the analysis services in sql server?

929

What are constraints?

985

Is it possible to update the views? If yes, how, if not, why?

1003

Comment,Datatypes are unlimited

2046

Write a SQL queries on Self Join and Inner Join.

1026

What are views used for?

992

Explain atomicity?

1024

What is a transaction and why is it important?

1063

What is the Main Difference between ACCESS and SQL SERVER?

1112

Explain in brief about Microsoft SQL server?

1063