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
- 8485 Views
- I also Faced
- E-Mail Answers
Answer Posted / vikas kant
select emp_name, sum(salary)
from emp
group by emp_name
having sum(salary)=130
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
How to list all objects in a given schema?
How can you find out how many rows returned in a cursor?
Define tool Manage Statistics in SQL Server 2000 query ?
in the physical file layout, where should the transaction log be stored in relation to the data file?
Can a database be shrunk with users active?
how to use DTS package in 2000,2005,2008 in sql server
Difference between 2NF &3NF ?
Write a SQL command to insert and update only a particular field?
What is difference between equi join and inner join?
What is the difference between cartesian product and cross join?
What are system databases into sql server (2005/2008) : sql server database administration
What is SubQuery in SQL Server 2008
How to create a new schema in a database?
What is the difference between a stored procedure and a user defined function?
what are constraints? Explain different types of constraints? : Sql server database administration
