1. Categories >> Software >> Databases >> SQL Server
  2. Suggest New Category

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

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 create user defined functions with parameters?

636

What is sql or structured query language?

680

what are the core components of SSRS?

92

Is t sql the same as sql server?

513

What is @@error in sql?

619




Find first and last day of current month in sql server

595

Explain error and transaction handling in sql server?

497

What are scalar functions in sql?

604

What do you understand by recursive stored procedures?

567

What is statement level trigger?

537

How to generate random numbers with the rand() function in ms sql server?

564

What are transactions in sql?

547

What are the different types of cursor?

603

What are scalar functions?

503

What is an example of a primary key?

507