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
- 8681 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
What is difference between clustered and non clustered index?
What is change data capture (cdc) in sql server 2008?
In how many ways you can invoke ssrs reports?
How to find a value in another dataset based on current dataset field (ssrs 2008 r2)?
What is 'write-ahead log' in sql server 2000 ?
In what three ways is the return statement used in a stored procedure?
What stored procedure can you use to display the current processes?
When is the use of update_statistics command?
Different types of keys in SQL?
What are the differences between ms sql server & oracle?
What does set rowcount do?
How to get a list of columns using the "sys.columns" view in ms sql server?
How to create a scrollable cursor with the scroll option?
What is normalization of database?
What is the difference between a function and a stored procedure?
