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
Define union, union all, minus, intersect?
What are the different types of lock modes in sql server 2000?
How to execute the cursor queries with "open" statements?
How and why use sql server?
What is 3nf normalization?
Why use identity in sql server?
What are types of subqueries?
What is clustered primary key?
How do I start sql server 2016?
How can you list all the columns in a database?
How to execute a sql statement using odbc_exec()?
What is triggers and its types?
List some major differences between triggers and stored procedures?
If a user does not have permission to a table, but has permission to a view created on it, will he be able to view the data in table?
How to list all user defined functions in the current database?