wat iz self join write qeriry for table
- 2 Answers
- 5023 Views
- Hewitt, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / 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 |
Answer / srinidhi patil
Joining A table to self is called as self join
| Is This Answer Correct ? | 2 Yes | 0 No |
what is the difference between reporting and testing? which one is good to choose as a carrer?
1.what is the approach while writing test cases in your project. 2.tell some intresting scenareo in your project
What kind of inputs do we need from the end user to start proper testing?
Can you explain the different maturity levels in staged representation?
what are the techniques(steps) to follow for writing test cases? could u explain me with brief real time example?
What r block box technique
What is way of writing testcases for database testing?
How to do credit card (banking application) security testing?
What is CMM-1,2,3,4,5 Level Company? How much levels are there like CMM?
Hi, This is vkram.I had completed my B.E in May 2005 & currently i am undergoing Testing Course. I want to join as a Fresher in any MNC. What should I tell why u r coming to testing field & what u did this 2 years?
How to write Test cases for pen in tabular form including all phase of test case like Test id, Test Objective, Prerequisite etc.
How many Test case we can write to test MS Excel(for System Testing)
Automation Testing 
