Interested to Buy Any Domain ? << Click Here >> for more details...
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
How to find bug in photos and videos ??
What are testing techniques? What is difference between general and specific?
What is defect removable efficiency?
Could anyone share FAQs for Test Manager position...
What does entry and exit criteria mean in a project?
Explain crud testing.
How to explain the Insurance project in the interview?
What are the differences between web applications and client and server applications?
Explain the advantages of automation over manual testing?
What are cookies?
Explain the importance of agile testing?
What will be the testcase for a uniquely generated number in the application?? i mean to say is, how will i conform the application is generating a unique value.... please do answer...
Write positive and negative test cases for forgot password?
What is error cusing tecnique
What is Stability and Performance Testing in Testing the TV
