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
Answers were Sorted based on User's Feedback
Answer / srikanth
select emp.name,salary.salary from emp,salary where
emp.id=salary.id and salary.salary>=10000
Is This Answer Correct ? | 5 Yes | 1 No |
Answer / 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 |
Answer / shahbaz
Try this one
this is the syntax....
SELECT EMPID, ENAME FROM EMPLOYEE INNER JOIN SALARY ON EMPID=ID AND SAL>600;
by kibria and shahbaz
Is This Answer Correct ? | 2 Yes | 1 No |
What is regular expression in php?
Write down the code for save an uploaded file using php?
What is the difference between abstract class and interface in php?
What is php sequence?
What is prepared statement in php?
What is the use of $_server and $_env?
What are the functions used in php?
What is helper library?
What is the main difference between require() and require_once()?
How can I execute a PHP script using command line?
What is isset and unset in php?
What is php routing?