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


Please Help Members By Posting Answers For Below Questions

Which is incorrect with respect to separating php code and html?

630


how to detect a mobile device using php

669


What is the use session in php?

649


What is singleton pattern in php?

560


What is the function used to change the root directory in PHP?

644






How to genrate report in wordpress cms

1887


Why php was called as personal home page?

623


Is server side a session?

572


What does the scope of variables means?

657


What is move_uploaded_file in php?

640


What is the maximum size of a table in mysql?

614


What is the use of token in php?

591


How to set cookies?

625


What is env in laravel?

618


Explain what is the difference between session and cookie?

621