SELECT Name FROM Employee WHERE salary =130

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?

Question Posted / supriya gupta

7 Answers
8764 Views
I also Faced
E-Mail Answers

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

Explain how to integrate the ssrs reports in application?

1017

What is a dbms wizard?

1022

What are the difference between primary keys and foreign keys?

966

How to create nested stored procedure?

1024

Explain magic tables in sql server?

1062

What is blocking and how would you troubleshoot it? : sql server database administration

1049

Explain temporary table vs table variable by using cursor alternative?

1001

How to create a local temporary stored procedure?

998

What is primary key and example?

960

Please explain go command in sql server?

1058

Do you know what is recursion? Is it possible for a stored procedure to call itself or recursive stored procedure?

996

What is data file in computer?

952

What are the different types of triggers in SQL SERVER?

1139

What is conditional split?

1084

What is the purpose of data source?

1042