wat iz self join write qeriry for table
- 2 Answers
- 5377 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 meant by beta testing?
How do you write DEFECT REPORT?
What is Usability and Compatibility testing?
What is inter-operability?
how do you determine what to test?
static and dyanamic testing
Describe V Model with the entry criteria of each Test Phase.
how to retrieve the test data?
what is diffrerence between build and version
Why would we not include these?
How do you find synchronisation problems normally?
How to do test if we have minimal or no documentation about the product?
Automation Testing 
