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
- 8680 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
Explain trigger and its types?
What is Cross Join and in which scenario do we use Cross Join?
What is ssrs?
How many types of relations are there between dimension and measure group? : sql server analysis services, ssas
when you create a database how is it stored? : Sql server database administration
Do you know what are the steps to process a single select statement?
Define candidate key, alternate key, and composite key.
What stored by the master? : sql server database administration
What do you mean by acid?
Do you know the different ddl commands in sql?
What is the difference between char and varchar2 datatype in sql?
What are views in ms sql server?
What are the differences between decimal and float in ms sql server?
Give main differences between "Truncate" and "Delete".
What do you mean by subquery?
