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


Please Help Members By Posting Answers For Below Questions

Define union, union all, minus, intersect?

648


What are the different types of lock modes in sql server 2000?

567


How to execute the cursor queries with "open" statements?

701


How and why use sql server?

632


What is 3nf normalization?

647






Why use identity in sql server?

636


What are types of subqueries?

638


What is clustered primary key?

644


How do I start sql server 2016?

608


How can you list all the columns in a database?

621


How to execute a sql statement using odbc_exec()?

653


What is triggers and its types?

627


List some major differences between triggers and stored procedures?

594


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?

621


How to list all user defined functions in the current database?

590