Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 8775 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
How do I setup a sql server database?
How to connect Azure federated root database and apply federation in entity framework?
what are the reporting service components in SSRS?
Create and insert into temp table in sql server?
How does Report Builder support Analysis Services cubes?
do you know what is a deadlock and what is a live lock? How will you go about resolving deadlocks? : Sql server database administration
What is sub-query in sql server?
Can we add an identity column to decimal datatype?
What happens on checkpoint?
Explain intellisense for query editing
Explain what is the purpose of sql profiler in sql server?
Which language rdl files made of?
What is primary key, unique key, and foreign key?
What stored by the msdb?
How can delete duplicate records in cte in sql server?
