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?
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
How will you know when statistics on a table are obsolete?
When is update_statistics command used?
What is the difference between primary key and unique constraints?
What command is used to delete a table from the database in the sql server and how?
where the connection string store in the database
Difference between DELETE and TRUNCATE?
How to create view in stored procedure sql server?
How many ways to create table-valued functions?
what are the types of indexes? : Sql server database administration
What is the difference between a view and a stored procedure?
How do I save a stored procedure in sql server?
What is normalization? Describe its different types.
Do you know what is a linked server in sql server?
What are joins in sql and what are the different types of joins?
What is a field name?