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
- 9019 Views
- I also Faced
- E-Mail Answers
Answer Posted / anonymous
select name as Sal
from emplyoee
group by id
having sum(salary)=130
| Is This Answer Correct ? | 3 Yes | 1 No |
Post New Answer View All Answers
What is read uncmmited?
What are advantages of ssrs or why we should use ssrs?
What is use of except clause? How does it differ from not in clause?
‘Order by’ is not allowed in a view how can you sort information from a view?
Do you know what is user defined datatypes and when you should go for them?
What are the various Operating system files that every SQL server 2005 database has and what is the purpose.
What is SubQuery in SQL Server 2008
What happens if the update subquery returns multiple rows in ms sql server?
Difference between aggregate functions of sql?
What are window functions in sql server?
What is a cube? : sql server analysis services, ssas
Can foreign key be duplicate?
What is sqlservr.exe - process - sql server (sqlex?press)?
Explain what is use of dbcc commands?
Why do we partition data?
