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 / ajay kumar
select sum(salary) as Sal from emplyoee
group by id
having sum(salary)=130
Is This Answer Correct ? | 8 Yes | 8 No |
Post New Answer View All Answers
Why do we use functions?
How can I know what locks are running on which resource?
What is the default fill factor value?
What are the advantages of user-defined functions over stored procedures in sql server?
How can I check if a view exists in a sql server database?
What is table level trigger?
How to delete an existing row with delete statements in ms sql server?
what protocol both networks use? : Sql server database administration
What are the results of running this script?
How to write a query with a right outer join in ms sql server?
What are different types of table joins?
What is use of attributehierarchyenabled? : sql server analysis services, ssas
Is there any difference between primary key and unique with the not null condition?
What is the recommended total size of your memory optimized tables?
Do you know the capabilities of cursors?