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
- 6658 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 correct and the most two common way to start and finish a PHP block of code?
How to download files from an external server with code in php?
what is interface in java.
How do I update php?
can you give me an example code of calling java script function in php variable using AJAX.or with out ajax??????
What is implode() in php?
How to create an empty array in php?
Tips to optimize the php script..... Suggestion for exception handling in php...
Explain why would we use === instead of ==?
What are the rules in creating php variable?
What is indexing how many types?
3 Answers DLF, Infosys, Net Solution, Vcare,
What is array filter php?
PHP 
