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
9028 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

Why transaction is important?

1025

Why use triggers?

1071

What are different types of roles provided by ssrs?

156

Is resultset an interface?

1040

Explain about analysis services?

1106

explain extended properties

1038

Explain cdc and sql injection?

1045

Mention the different authentication modes in sql server.

1109

Tell me time data type, datetime2, datetimeoffset data type in sql server 2008?

1034

What are relationships and mention different types of relationships in the dbms

1017

what are the reporting service components in SSRS?

172

What are the essential components of sql server service broker?

1069

What is the usage of sign function?

1178

Which are the new data types introduced in sql server 2008?

933

Explain isolation levels that sql server supports?

1087