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
- 7240 Views
- I also Faced
- E-Mail Answers
Answer Posted / kuntal bhattacharya
select name from
(select name ,sum(salary) as Sal from emplyoee
group by id ,name)as s
where Sal=130
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
Can we add our custom code in ssis?
What is faster join or union?
Explain triggers?
How to retrieve error messages using mssql_get_last_message()?
What are exact numeric data types in ms sql server?
if no size is defined while creating the database, what size will the database have? : Sql server administration
What do you understand by physical_only option in dbcc checkdb?
How you can add messages to the nt event log from within a stored procedure?
What are entities and relationships?
How can sql server instances be hidden? : sql server security
What is @@error in sql?
What is deploy, process and build? : sql server analysis services, ssas
What is a primary key?
What is the difference between commit and rollback?
How to drop an existing user defined function in ms sql server?
