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
- 5834 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 the tags in PHP is not a valid way to begin and end a PHP code block?
How to replace a substring in a given string?
Is null check in php?
How many open modes available when a file open in PHP?
Is it possible to extend the execution time of a php script?
When are you supposed to use endif to end the conditional statement?
How do you connet mysql database with php?
How to terminate the execution of a script in PHP?
How to return a value back to the function caller?
What is pdo classes?
Define metaphone()?
What is the use of mvc in php?
What is the use of header() function in php?
What is the difference between explode and split?
Which function parses an English textual date or time into Unix timestamp in PHP.
