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 / anonymous
select name as Sal
from emplyoee
group by id
having sum(salary)=130
| Is This Answer Correct ? | 3 Yes | 1 No |
Post New Answer View All Answers
User wants only to display only pdf as export option in report manager. How to achieve this?
What is logshipping and its purpose?
Explain what you mean by 3 tier architecture.
What are the different types of stored procedures?
How to update a field in SQL after ALTERING a row?
What do you understand by intent locks?
Explain what are the restrictions that views have to follow? : SQL Server Architecture
What is rank function?
How will you make an attribute not process? : sql server analysis services, ssas
what is the system function to get current user's user id? : Sql server database administration
What is a result set object returned by mssql_query()?
What are the advantages of using a stored procedure?
How to concatenate two strings in SQL Server.
What is meant by referential integrity?
How will you find out if there are expensive SQL statements running or not?