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
- 8678 Views
- I also Faced
- E-Mail Answers
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
What is b tree index?
How to insert multiple rows with a subquery?
How would you add a section to a table?
What stored by the tempdb ? : sql server database administration
What are joins in sql and what are the different types of joins?
What is cte (common table expression)?
What is buffer cash and log cache in sql server?
Explain what is sql server english query?
Tell me about normalization in DBMS.
Do you know sql server 2008 introduces automatic auditing?
What is difference between createstatement and preparedstatement?
In case you have filters in your report, when filters will be applied in cached report instance?
List out a number of the wants to setup a SQL Server failover cluster?
What is replication with database mirroring? : sql server database administration
what are acid properties? : Sql server database administration
