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?
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
What should be the fill factor for indexes created on tables? : sql server database administration
How do I setup a sql server database?
If the job running very slow what is the action you do
What is the template in sql?
What is the primary use of the model database?
Do I need a report server to run reports in my application?
How do you test your database? : sql server database administration
Why de-normalization required?
Can you get second highest salary from the table?
Explain time data type in sal server 2008?
How many clustered indexes there can be on table ?
How to select true false based on column value in sql server?
How to sort the query output with order by clauses in ms sql server?
Does sql server 2000 full-text search support clustering?
What is ddl and dml commands?