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?
- 7 Answers
- 7582 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
Define indexes?
How to execute the cursor queries with "open" statements?
Can we perform backup restore operation on tempdb?
What are the basic functions for master, msdb, model, tempdb and resource databases?
How to insert a new row into a table with "insert into" statements in ms sql server?
What are the disadvantages of merge replication?
Why use cursor in sql server?
When do you think a developer should use sql server-based cursors?
what are constraints? : Sql server database administration
How can you check the level of fragmentation on a table?
How do you identify a foreign key?
How do you run a trace?
Differentiate between a primary key and a unique key.
What are triggers? How many triggers you can have on a table? How to invoke a trigger on demand?
Explain contrast amongst grouped and non-bunched records?
