wat iz self join write qeriry for table
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 |
Can anyone give me the example of High Priority and High severity defect. Please dont give me answers like Spelling mistakes or logo missing something like that. Give me some real time example from your application. Thanks in Advance.
What is Stub and Driver ? What functions are used in stubs and driver?
If I have written the test cases for any module.And some features are added/removed to & from that module then what should I do with test cases?
What is network Entry procedure in WIMAX -TEch mahidra question?
what is the difference between test case and test script?
What is Retesting & Regression Testing? When do we use retesting & regression testing(i.e In what situation)? Please clear me.
how to write a test case for check box like in gmail or yahoo
whar are the contents in db testing test case template
Diff. between system test cases & UAT test cases.
What is System Testing Phase? Which types of testing will be conducted in system testing phase?
who prepares traceability matrix in ur company either jr tester or sr tetser or test lead?
what is black phase in SDLC