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
- 9020 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 an execution plan? When would you use it?
How to convert a numeric expression from one data type to another?
What is executereader?
What is the maximum size per database for sql server express?
What are the different types of lock modes in sql server 2000?
What is xml datatype?
What are the different Authentication modes in SQL Server and how can you change authentication mode?
What’s the distinction between dropping a info and taking a info offline?
How many types of triggers in sql server?
What are the difference between primary keys and foreign keys?
What is a livelock?
What command would you use to create an index?
What is use of except clause?
How to rebuild all indexes on a single table?
What is named query? : sql server analysis services, ssas
