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
Build with fixes has been deployed on QA environment if asked by your manager to reproduce how can you reproduce the issues? (by using the previous build) Can you access the previous build? If so ,what are the tools or how can you access?
Can you explain decision tables?
I have an Interview about Guidewire claimcenter,so could you provide any info regd it?.I would really appreciate any kind of help- email at hvshah2001@gmail.com
WHAT IS PROTOCAL TESTING..EXPLAIN? L2, L3 PROTOCALS TESTING MEANS WHAT?EXPLAIN BRIEFLY
How to overcome pesticide paradox?
What is date driven testing?
what are the possible test cases for online jobs search portal..if its a job seeker module and any 1 if u had worked on this proj pls share the bugs with sev and priority pls frends i need replies for these queries ..thanks in advance
What is ofx testing?
How can you use technology to solve problem?
What is test startegy?
Give the real-time example for back-to-back testing?
When we are recording in WinRunner and interact with the AUT, what does WinRunner do?
What do you do if the bug that you found is not accepted by the developer and he is saying its not reproducible.
Have you prepared traceability matrix and how to prepare it?
what are the common errors while doing integration,system,functional,regression,user acceptance testing? can anybody please let me know the answers it is too urgent???