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?
- 7 Answers
- 7239 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
Write the syntax for stuff function in an sql server?
Explain a checkpoint?
What are the differences between substr and charindex in sql server.
Write a SQL command to insert and update only a particular field?
Explain Geography datatype in SQL Server
what is package and it uses and how can u call a package
What function does a database engine serve in the sql server?
Can the query output be sorted by multiple columns in ms sql server?
What is the log shipping?
Explain what are various ways to enhance the ssrs report?
Explain what role entity and relationship play in an ER diagram.
How will you optimize a stored procedure optimization?
What are the different sql server versions?
What are views in ms sql server?
What is scd (slowly changing dimension)? : sql server analysis services, ssas
