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
8787 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

How to delete all rows with truncate table statement in ms sql server?

1011

Explain indexes disadvantages?

1102

Why olap is used?

986

How can I know what locks are running on which resource?

965

How many servers can we create in a single subscription?

162

What is the default server name for sql server?

1186

Explain external key management in sql server 2008

896

What is a covering index?

993

What is data compression?

1024

What are some of the pros and cons of not dropping the sql server builtinadministrators group? : sql server security

997

What is an index in sql?

1017

Explain use of expression builder.

1033

What are indexes in sql?

1292

What are trace flags?

1041

Explain system functions or built-in functions? What are different types of system functions?

989