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
- 8768 Views
- I also Faced
- E-Mail Answers
Answer Posted / vikas kant
select emp_name, sum(salary)
from emp
group by emp_name
having sum(salary)=130
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
How do use Having,Group by,Group function in SQL?
What is wide table?
What is difference between after and before?
Explain intellisense for query editing
How to send a ssrs report from ssis?
Why does sql studio use a single registered database repository? : sql server management studio
what are acid properties? : Sql server database administration
Explain what is meant by replication of database?
How do indexes help, types?
there is a trigger defined for insert operations on a table, in an oltp system. The trigger is written to instantiate a com object and pass the newly inserted rows to it for some custom processing. What do you think of this implementation? Can this be implemented better? : Sql server database administration
Explain view in sql server?
What will happen if a column containing char type data is changed to the nchar data type?
Can an automatic recovery be initiated by a user?
What is query cost in sql server?
What is sql server profiler?
