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 a static method php?
Explain about the connective abilities of the PHP?
Is ruby on rails php?
What is a static variable in php?
How to find the length of a string?
does PHP support foreign key and Rollback?yes or not.if not then why. how will you done these concept in php?
1 Answers Avanigoradia, Primus Global,
What are php errors?
write code to find the date difference b/w two given date using PHP not MYSQL function?
3 Answers HyperQuality, Synctra Solutions,
Why shouldn't I use mysql_* functions in php?
What is sql injection in php?
What is $_ get in php?
Explain the importance of the function htmlentities.