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
8682 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 you can deploy an SSRS report?

146

What do you understand by replication in sql server? Mention the different types of replication in sql server.

932

Can we use trigger new in before insert?

898

how to create “alternate row colour”?

146

Where is my database stored on the hard disk in ms sql server?

1041

What is the difference between char, varchar and nvarchar?

1009

What is the difference between the export /import functions in sql studio and standalone sql manager? : sql server management studio

1122

What is difference between foreign key and unique key?

997

Explain sql server service broker?

958

What is a collation?

1074

Can we deploy SSRS reports on our personal website?

168

what are the three command line utilities and what are their primary functions?

144

Define constraints and give an example of their use?

1027

What is the use of @@spid?

983

Explain syntax for viewing, dropping and disabling triggers?

932