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
- 8760 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 the current limitation of the size of SQL Azure DB?
What is the default sql server instance name?
What are the basic features of a trigger in ms sql server?
What is cube dimension? : sql server analysis services, ssas
How do I repair damaged sql server mdf file database? In previous day my mdf file has got damage due to unknown reasons then I used dbcc chekcdb command but it failed, MDF file is important for me, I don’ know that how to get back mdf file data. Please anyone suggest me?
How to return the second 5 rows in ms sql server?
Can we write ddl in trigger?
How to use group functions in the select clause in ms sql server?
Can we use having clause without group by?
what stored procedure can you use to display the current processes? : Sql server administration
When does the auto update index statistics feature in sql server turn itself on?q) what specific conditions database should meet, before you can bulk copy data into it using bcp?
What is a derived table?
When would you use a before or after trigger?
What is dynamic cursor in SQL SERVER?
Explain about unique identifier data type in sql server?
