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
- 8486 Views
- I also Faced
- E-Mail Answers
Answer Posted / kuntal bhattacharya
select name from
(select name ,sum(salary) as Sal from emplyoee
group by id ,name)as s
where Sal=130
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
how would you troubleshoot blocking? : Sql server database administration
What Are the Main Features of SQL Azure?
How to perform backup for certificates in sql server? : sql server security
Can coalesce return null?
Can we add a cpu to sql server?
How to set the current database in ms sql server?
What are rest-style architecture's?
Write a code to select distinct records without using the DISTINCT keyword.
What is an identity column in insert statements?
What is the optimal disk configuration for a database server and what raid configurations would you use if budget is not a constraint?
How to provide values to user defined function parameters?
How many clustered indexes can be created on a table? I create a separate index on each column of a table. what are the advantages and disadvantages of this approach?
How many joins in sql server?
What are cursors? Explain the different types of cursors Enlist a few disadvantages of cursors.
What is the difference between DataRow.Delete() and DataRow.Remove()?
