Try this one this is the syntax.... SELECT EMPID, ENAME FROM EMPLOYEE I

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

Question Posted / shahbaz

3 Answers
6607 Views
Net Solution, I also Faced
E-Mail Answers

Answer Posted / 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

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

How do you define a constant?

926

I am trying to assign a variable the value of 0123, but it keeps coming up with a different number, what is the problem?

916

How do I stop php artisan serve in windows?

912

Which framework is best for php?

916

Name some of the functions in php.

936

What is the function in PHP do not return a timestamp?

969

What is prepare in php?

961

Which php global variable is used for uploading a file?

972

What is config file in php?

976

What is session in PHP. How to remove data from a session?

933

What is an array in php?

1055

Is php used in 2019?

939

How to get number of days between two given dates using PHP?

861

How can i execute PHP File using Command Line?

924

When sessions ends?

906