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
- 7592 Views
- I also Faced
- E-Mail Answers
Answer Posted / anonymous
select name as Sal
from emplyoee
group by id
having sum(salary)=130
| Is This Answer Correct ? | 3 Yes | 1 No |
Post New Answer View All Answers
What is 5nf in normalization form?
How to create a user name in a database?
Explain how dts is used to extract, transform and consolidate data?
How can I know what locks are running on which resource?
What were the latest updates to SQL Azure service?
What are the new features of sql server 2008 r2 reporting service?
How to edit table in sql server 2017?
What happens if time-only values are provided as date and time literals?
What are the approximate numeric data types?
What is Dependency Injection and provide example?
how to overcome kernel isssues
What is acid mean in sql server?
what is a schema in sql server 2005? : Sql server database administration
What is 'write-ahead log' in sql server 2000 ?
Write a sql query to delete duplicate records from a table called table1
