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

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 / anonymous

7 Answers
8488 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

Please Help Members By Posting Answers For Below Questions

User wants only to display only pdf as export option in report manager. How to achieve this?

247

What is logshipping and its purpose?

946

Explain what you mean by 3 tier architecture.

1020

What are the different types of stored procedures?

1069

How to update a field in SQL after ALTERING a row?

1183

What do you understand by intent locks?

956

Explain what are the restrictions that views have to follow? : SQL Server Architecture

993

What is rank function?

978

How will you make an attribute not process? : sql server analysis services, ssas

1011

what is the system function to get current user's user id? : Sql server database administration

951

What is a result set object returned by mssql_query()?

1078

What are the advantages of using a stored procedure?

942

How to concatenate two strings in SQL Server.

1082

What is meant by referential integrity?

959

How will you find out if there are expensive SQL statements running or not?

969