SELECT t1.EmpNAME FROM EMPLOYEE as t1 INNER JOIN SALARY as t2 ON t1.EmpID

we have two tables first one is EMPLOYEE
having EmpID, EmpNAME,
Second table is SALARY table
having id, salary
Write a query to get name of those person who having more
than 10000$ salary

Question Posted / pandian.m

3 Answers
6774 Views
Net Solution, I also Faced
E-Mail Answers

Answer Posted / pandian.m

SELECT t1.EmpNAME FROM EMPLOYEE as t1
INNER JOIN SALARY as t2 ON t1.EmpID=t2.id
GROUP BY t1.EmpID HAVING t2.salary>10000

Is This Answer Correct ?

2 Yes

1 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What is a persistent cookie in php?

988

What does $_ post mean in php?

1073

What is the difference between get and post in php?

1037

Can php use gettext?

1036

Tell me how to get the value of current session id?

948

What is final class and final method in php?

1061

Is php developer in demand?

970

How to convert one date format into another in php?

917

How many columns can be added in a table in mysql?

997

What is the sign to start variables in PHP?

1103

Is c similar to php?

927

Tell me what is the main difference between require() and require_once()?

988

Is set in php?

973

Is PHP an open source software?

1064

What is helper library?

934