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

Why do we need normalization?

977

Can binary strings be converted into numeric or float data types?

1098

What are drilldown reports?

160

What is star, snowflake and star flake schema? : sql server analysis services, ssas

1230

How to query multiple tables jointly?

1042

What are constraints?

1060

How do I view a script in sql server?

1088

What are the new data types are introduced in sql 2000?

949

Explain about SQL server 2005?

1026

Why is sql server log file full?

1080

How can you check the level of fragmentation on a table?

1087

When is the use of update_statistics command?

1057

What is difference between line feed ( ) and carriage return ( )?

951

What is ssrs?

135

what is a transaction and what are acid properties? : Sql server database administration

1089