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
- 8777 Views
- I also Faced
- E-Mail Answers
Answer Posted / ajay kumar
select sum(salary) as Sal from emplyoee
group by id
having sum(salary)=130
| Is This Answer Correct ? | 8 Yes | 8 No |
Post New Answer View All Answers
Explain various data region available in ssrs with their use?
Explain the cursor lock types?
You want to implement the one-to-one relationship while designing tables. How would you do it?
What is truncate table?
Are there any preferred steps that need to be taken care of before starting the installation of sql server 2000?
How do I get to sql server configuration manager?
What are the events recorded in a transaction log?
Explain what is “asynchronous” communication in sql server service broker?
How can you set the threshold at which sql server will generate keysets asynchronously?
What happens if null values are involved in string operations?
what is a schema in sql server 2005? : Sql server database administration
System variable and temporary variables
How to set database to be read_only in ms sql server?
Name and describe few console utilities for ssrs?
What is sql profiler. What are the default templates with it? : sql server database administration
