Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 3 Answers
- 6916 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
What is difference between base_url and site_url?
What are the difference between overloading and overriding in oops?
How do I make a reset button in html?
How to enable error reporting in php?
Why framework is used in php?
What are php strings?
What is constructors and destructors?
How can you encrypt password using php?
What is T_PAAMAYIM_NEKUDOTAYIM?
What advance thing in php7?
Write a program using while loop in php?
Tell me are parent constructors called implicitly inside a class constructor?
if you run the app program all vendor open items are cleared but is it possible to reverse the again again open items please tell me the answer
How to access standard error stream in PHP?
How do you sort an array in php?
