Answer Posted / manish
Sometimes you need to join a table to itself. To find the
name of each employee’s manager, you need to join the
EMPLOYEES table to itself, or perform a self join.
The Query:
SELECT worker.last_name || works for || manager.last_name
FROM emp worker, emp manager
Where worker.emp_id = manager.emp_id;
| Is This Answer Correct ? | 8 Yes | 1 No |
Post New Answer View All Answers
Architectural structure of the insurance project?
hi every one can you send me ISTQB Course material on my Email id deeptimundra997@gmail.com
What is the difference between manual testing and automation testing?
How many types of api testing are there?
What ishigh severity, low priority bug?
tell wat u did in ur banking project?
What different types of manual testing are there?
How do you determine user soad for a perf test of a Web application?
what r u r responsibilities in current project
through which phases a software ttester need to pass like as a junnior test engineer,team lead,project lead,etc.? which is the final stage of your promotion and how will u achieve?
qtp9.2 and qtp10.0 difference
how will the test plan is pepared in ur organisation>?
Test approach to windows scheduler?
integration test cases for mouse and keyboard
Can anyone write test cases on google account creation page in the testing template format , urgent pls and explain if possible how to execute also