Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 6783 Views
- Net Solution, I also Faced
- E-Mail Answers
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 |
Which function is used in php to search a particular value in an array?
Is it possible to submit a form with a dedicated button?
How would you determine the size of a file in php?
What is different types of visibility?
What is the use of $_request variable?
Hello Friends,I am seeking for a job in php having 9 months. exp.Please suggest any company openings.
How can you encrypt password using php?
What is difference between single quotes and double quotes in php?
What is the delimiter syntax is PHP's default delimiter syntax
What function do we use to find length of string, and length of array?
Single choice objective PHP question...
What is empty () in php?
PHP 
