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
- 8499 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
What is the difference between lock, block and deadlock? : sql server database administration
How to convert a unicode strings to non-unicode strings?
What happens to a statement batch if there is a compilation error?
What is amo? : sql server analysis services, ssas
What is the stuff and how does it differ from the replace function?
Do you know spatial data types - geometry and geography in sql server 2008?
How to round a numeric value to a specific precision?
How does index makes search faster?
Can we do dml on views?
Do you know what are pages and extents? : SQL Server Architecture
List out the differences between global and local temp tables in sql server?
What is a table called, if it has neither cluster nor non-cluster index? What is it used for?
hi, the following are the outputs of sp_spaceused and sp_tempdbspace sp_spaceused ------------ database size unallocated size tempdb 77752.95 MB 28026.99 MB sp_tempdbspace ------------- database size spaceused tempdb 77752.945312 1.007812 the unused space in sp_spaceused is nearly 28 Gb and in sp_tempdbspace is nearly 76 Gb cany any one explain about this output and why its giving different results.
What are the restrictions while creating batches in sql server?
How to check if stored procedure is running in sql server?
