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
- 6918 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
What is the Default syntax used in PHP?
How to check your php installation?
How do I repair phpmyadmin?
Why many companies are switching their current business language to php?
Explain how can we increase the execution time of a php script?
What are the string function in php?
How can we pass the variable through the navigation between the pages?
How to create a text file in PHP?
How arrays are used in php?
Why ide is recommended for use while programming with php?
How to define a function with any number of arguments?
What difference between require() and require_once()?
What is the use of header() function in php?
What are the features of php 7?
What is an array in php?
