select name from (select name ,sum(salary) as Sal from emplyoee group by

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 / kuntal bhattacharya

7 Answers
8774 Views
I also Faced
E-Mail Answers

Answer Posted / kuntal bhattacharya

select name from
(select name ,sum(salary) as Sal from emplyoee
group by id ,name)as s
where Sal=130

Is This Answer Correct ?

2 Yes

0 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

Do you know what is recursion? Is it possible for a stored procedure to call itself or recursive stored procedure?

1003

What are the ways available in sql server to execute sql statements?

1143

Explain indexed views?

988

What is sql collation?

1220

Explain collation?

1071

Can primary key be a foreign key?

1063

What is sql azure database?

206

What is a virtual table in sql?

1003

Is the log file is a part of file group?

1043

Explain comment on transactions?

1012

how you can move data or databases between servers and databases in sql server? : Sql server administration

977

Does the unique constraint create an index?

1069

What is save transaction and save point?

1212

How to trouble shoot if unable to connect SQL Server

2000

What is single-user mode?

947