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 |
How many types of php frameworks are there?
If anybody integrate "First Data Global Payment Gateway" in your site?
What are the uses of explode() function?
Tell me what does the php error 'parse error in php - unexpected t_variable at line x' means?
how to get substring of string without using substr() function in php ????
How is it possible to remove escape characters from a string?
What is the purpose of the following files having extensions 1) .frm 2) .myd 3) .myi? What do these files contain?
What is the diffrence between GET,POST and REQUEST Method.
Why do we use php?
How can I reset an array in PHP?
4 Answers Rushmore Consultancy, TCS,
What is the difference between include and include_once ? Which is one is good in terms of performance ?
What is multidimensional array in php?