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
8483 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 is the default schema of your login session in ms sql server?

996

Which data type columns are the best candidates for full-text indexing?

919

What is explicit mode in sql server?

1018

How you can minimize the deadlock situation?

983

How to list all stored procedures in the current database using ms sql server?

1058

Hi all, can any one please tell me the difference between sql server 2008 and orace 9i

1902

Do you know the cursor optimization tips?

932

What is a with(nolock)?

927

What is the difference between insensitive and scroll cursor?

1072

What is the use of group by clause?

902

Can you please explain the difference between primary keys and foreign keys?

1059

Difference between uniqe index and uniqe constraint?

918

What is the difference between ddl,dml and dcl commands?

1059

Give a example to search fr a string in all stored procedure in sql server.

914

How to return the date part only from a sql server datetime datatype?

1023