Select id, name, sum(salary) from emp group by id, name Having sum(salary

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 / kumar.t

7 Answers
8679 Views
I also Faced
E-Mail Answers

Answer Posted / kumar.t

Select id, name, sum(salary) from emp
group by id, name
Having sum(salary) =130

Is This Answer Correct ?

0 Yes

0 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

what data regions are and what are the different data regions?

141

explain different types of constraints? : Sql server database administration

941

What is merge statement?

1067

How do I partition a table in sql server?

1020

What are the difference between primary key and unique key? : sql server database administration

922

How to include text values in sql statements?

1020

What are sql server procedures?

958

Which sql server table is used to hold the stored procedure script?

928

Explain different types of BACKUPs avaialabe in SQL Server? Given a particular scenario, how would you go about choosing a backup plan?

1016

Explain what is sql server english query?

1029

What are the methods used to protect against sql injection attack?

1046

Can you explain various data region available in ssrs with their use?

962

How many joins in sql server?

929

What is the difference between a view and a stored procedure?

1018

How to start and end transact-sql statements?

1005