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

What are sql server functions?

978

How to store and query spatial data?

993

What does truncate do?

934

How to loop through result set objects using mssql_fetch_array()?

1076

Is the primary key column of a table an index in ms sql server?

962

What is difference between temp table and cte?

1019

What is the use of sign function?

1124

What are the disadvantages of primary key and foreign key in SQL?

1116

What are temporal tables in sql server 2016?

883

When does a workload on SQL Azure get throttled?

131

You accidentally delete the msdb database what effect does this have on your existing sql databases, and how do you recover?

987

What are subqueries in sql server?

1120

What is use of dbcc commands?

1071

What are the types of database recovery models?

1123

Which event (check constraints, foreign key, rule, trigger, primary key check) will be performed last for an integrity check?

1007