select Name as Sal from emplyoee group by Name 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 / mahavir bansal

7 Answers
8776 Views
I also Faced
E-Mail Answers

Answer Posted / mahavir bansal

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

Is This Answer Correct ?

17 Yes

3 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

Types of Authentications in Sql Server? How user gets authenticated through windows authentication?

1063

Define primary key?

1145

Can we return Data from 4(more than 1) tables in stored procedure?

1062

How to verify a login name with sqlcmd tool?

1231

Can we update data in a view?

1040

List the types of recovery model available in sql server?

932

How do I partition a table in sql server?

1050

Tell me in brief how sql server enhances scalability of the database system?

996

How do you rename a table in sql server?

1038

How to create database with physical files specified in ms sql server?

1005

What is difference in performance between insert top (n) into table and using top with insert?

1059

How to compose an inquiry to demonstrate the points of interest of an understudy from students table whose name begins with k?

1099

Tell me about pre-defined functions of sql?

1115

I have all the primary data files, secondary data files as well as logs. Now, tell me can I still restore the database without having a full backup? : sql server database administration

1123

Can we use where clause with group by?

911