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 / mahavir bansal
select Name as Sal from emplyoee
group by Name
having sum(salary)=130
Is This Answer Correct ? | 17 Yes | 3 No |
Post New Answer View All Answers
Can sql server 2016 run on windows 7?
Explain about remote stored procedure?
How do you delete duplicate rows in sql server?
What are the key configuration files for sql server reporting services ?
What are scheduled tasks in sql server?
What is the difference between indexing and hashing?
What is a group function explain with an example?
Explain syntax for viewing trigger?
What are translations and its use? : sql server analysis services, ssas
Do you know hot add cpu in sql server 2008?
What are the different SQL Server Versions you have worked on?
What are subqueries in sql server? Explain its properties.
What are trace flags and mention a few common trace flags used with sql server?
How to check table values in sql server?
Difference between DELETE and TRUNCATE?