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
- 9025 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
What is difference between index and primary key?
How to create nested stored procedure?
What is the query and subquery?
Do you know what is sql injection?
Explain the properties of sub-query in sql server?
Explain time data type in sal server 2008?
How to list all dsn entries on your local machine using odbc_data_source()?
How to write a query with a full outer join in ms sql server?
Difference between group by clause and having clause in SQL?
What is instead of trigger sql server?
You have a table ‘test’ which is a copy of northwind employee table you have written a trigger to update the field ‘hiredate’ with the current date
role of sql sever 2005 in database rather than any other database
What are the types of resultset?
Can an entity have two primary keys?
What are the triggers in sql?
