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
- 6647 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 |
What are the advantages of stored procedures in php?
Write a program in php to check whether a number is prime or not?
what is interface in java.
How do i explode this string '||25||34||73||94||116||128' i need to have a array like this array ( 0 => '25', 1 => '34', 2 => '73', 3 => '94', 4 => '116', 5 => '128' ) explode("||", $array); didnt work for me i get this array array ( 0 => '', 1 => '25', 2 => '34', 3 => '73', 4 => '94', 5 => '116', 6 => '128', )
What is php glob?
What are the features and advantages of object-oriented programming?
What is the use of limit in mysql?
What is the function of mysql_real_escape_string in php?
How do you develop your own PHP extension ?
How many ways there are to fetch the data from the Database?
What is the use of friend function?
What is array and function?
PHP 
