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
- 8672 Views
- I also Faced
- E-Mail Answers
Answer Posted / anonymous
select name as Sal
from emplyoee
group by id
having sum(salary)=130
| Is This Answer Correct ? | 3 Yes | 1 No |
Post New Answer View All Answers
As per your opinion what are the five top responsibilities of a dba? : sql server database administration
Explain about builtinadministrator?
Can you index views?
Explain filtered indexes benefits?
What is difference between delete & truncate commands?
explain what is a deadlock and what is a live lock? How will you go about resolving deadlocks? : Sql server database administration
1.what are diff types of joins , and explain diff between cross join and full outer join 2.diff types of views 3. Diff types of index 4. What is diff b/w stores procedure and function procedure 5.diff between double and int in SQL 6.diff between char and varchar in SQL. 7.Oracle or SQL whice you will preferred and why.
Explain different forms of normalization?
Sql server reporting services vs. Crystal reports.
Can we insert data into a view?
What are Row versions of DataRow?
Explain user defined functions?
What is difference between materialized view and view?
How do we know if any query is retrieving a large amount of data or very little data?
Explain an incremental backup?
