we have two tables first one is EMPLOYEE having EmpID, EmpNAME, Second table i

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 / sumit manchanda

3 Answers
6923 Views
Net Solution, I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

we have two tables first one is EMPLOYEE having EmpID, EmpNAME, Second table is SALARY table hav..

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

we have two tables first one is EMPLOYEE having EmpID, EmpNAME, Second table is SALARY table hav..

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

we have two tables first one is EMPLOYEE having EmpID, EmpNAME, Second table is SALARY table hav..

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

Post New Answer