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
6657 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 exactly is validating and sanitizing?

997

How to enable parsing?

1041

Tell us how can we access the data sent through the url with the post method?

968

How can we display information of a variable and readable by human with php?

1035

How do you destroy a particular or all Sessions?

967

What are the difference between abstract class and interface in oops?

962

Which function is used in php to delete a file?

989

What is $this in php?

939

What is parent __construct ();?

975

Is ruby on rails php?

929

How to create a directory?

995

What is the difference between for and foreach in php?

1002

Is php a case sensitive language?

1124

How can we destroy the cookie in php?

945

How can we make a constant in php?

962