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?
Answer Posted / supriya gupta
SELECT Name FROM Employee
WHERE salary =130
| Is This Answer Correct ? | 1 Yes | 6 No |
Post New Answer View All Answers
how can you select rexcord(rows) from table A which is not present in Table B . Id being the FK in Table B referencing to ID Table A
How you provide security to cube? : sql server analysis services, ssas
Difference between Logical Page and Physical Page in SSRS.
What do you understand by triggers?
Explain about unique identifier data type in sql server?
What do you understand by mirroring?
What is a ddl statement?
How to invoke a trigger on demand?
Why use “nolock” in sql server?
What are the new features introduced in SQL Server 2000? What changed between the previous version of SQL Server and the current version?
What is updatable resultset?
Explain transaction server consistency?
How to divide query output into multiple groups with the group by clause in ms sql server?
What is the difference between coalesce() & isnull()?
What is efficiency data?