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
- 8487 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 are the types of database schema? : sql server analysis services, ssas
What are the character string functions supported by sql server 2005?
what is bit datatype and what's the information that can be stored inside a bit column? : Sql server database administration
What is the need for group functions in sql?
What functions can a view be used to performed?
How to set the current database in ms sql server?
‘Order by’ is not allowed in a view how can you sort information from a view?
Can we add an identity column to decimal datatype?
How to convert numeric values to integers in ms sql server?
What is partitioned view?
What is extent? Types of extents?
What are various ways to enhance the ssrs report?
What is temporal table?
What is a mixed extent?
How to run sql server 2005 books online on your local system?
