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
- 7584 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
Do you know what is user defined datatypes and when you should go for them?
how can you attach more than 20 ldf files in sql server
According to you what goes into making the best database administrator? : sql server database administration
you added a row to a view, but the row is not shown on the view. Explain how this can happen, and how you can remedy the situation
What is save transaction and save point?
What is the template in sql?
Explain an automatic checkpoint
what’s the difference between Covering Indexes and Clustered Indexes ? how to use clustered index small ?
How many joins in sql server?
What is #temp and @table variable in SQL server?
What the class forname () does?
Explain table valued parameters in sql server? Why tvp used?
What are the components of sql server service broker?
What is exclusive locks?
Explain the dbcc pintable command when would you use it?
