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
- 6606 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 |
Define urlencode() and urldecode() used in php?
How can you increase the maximum execution time of a script in php?
How can we encrypt and decrypt a data present in a mysql table using mysql?
Can we extend two classes in php?
What is cookie and why do we use it?
Explain the difference between array_merge() and array_combine()?
Is server side a session?
Would you initialize your strings with single quotes or double quotes?
What is get and post method in php?
What is php static function?
How do you check if an arraylist is empty?
What enctype is required for file uploads to work?
PHP 
