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
Answer Posted / 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 |
Post New Answer View All Answers
How to avoid the undefined index error?
How to get number of days between two given dates using PHP?
What software is required to run php?
What is a PHP Filter?
Write a program to display a table of any given number?
What is array function in javascript?
How can you increase the maximum execution time of a script in php?
What is use of echo in php?
How do I start a php session?
What is different types of visibility?
What advance thing in php7?
Which is variable cost?
How can I embed a java program in php file and what changes have to be done in php.ini file?
What is the use of mysqli_real_escape_string() function?
How to access a specific character in a string?