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
6609 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 do you mean range() in php?

1040

How does api connect to database?

999

What is php used for?

925

What are psrs?

1029

What is php session and how it works?

948

Is it possible to protect special characters in a query string?

946

What are different types of runtime errors in php?

1018

What is new static in php?

941

Explain briefly about a search-friendly site looks like?

839

Is empty java?

973

How check submit button is clicked in php?

943

Can we extend multiple classes in php?

984

What is the delimiter syntax is PHP's default delimiter syntax

1199

What is slim framework?

894

What is the difference between md5(), crc32() and sha1() crypto on php?

1014