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
- 8584 Views
- I also Faced
- E-Mail Answers
Answer Posted / ajay kumar
select sum(salary) as Sal from emplyoee
group by id
having sum(salary)=130
| Is This Answer Correct ? | 8 Yes | 8 No |
Post New Answer View All Answers
Explain about integration services of Microsoft SQL server?
How to display a past time in days, hours and minutes?
What is a deadlock and what is a live lock?
How to use subqueries with the in operators in ms sql server?
What is the purpose of update statistics and scope_identity() function?
When setting replication, is it possible to have a publisher as 64 bit sql server and distributor or subscribers as a 32 bit sql server?
Can you explain the disadvantages/limitation of the cursor?
What is the need for indexing?
Explain magic tables in sql server?
Is it important for a database administrator to understand the operating system and file access?
What is difference between global temporary tables and local temporary tables?
What is a trigger in sql server?
What are the difference between clustered and a non-clustered index?
What are different types of data sources?
What are distinctive joins find as a part of sql?
