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 |
what comments have u given in peer review? tell me at least 3 comments what u have given? july27 brahma412@yahoo.co.in
Before starting to write a script, how will you find the test cases that have the same functionality? And how will you maintain the code?
wht r 6 sigma standards
How to write Negative test cases?
12 Answers CarrizalSoft Technologies, Infosys, Microsoft, Ybrant Technologies,
what is the entry and exit criteria for system testing in v model
What different impact rating’s you have used in your project?
Explain V.model
What knowledge I must have as a 3 yrs. manual tester??
how to retrive only second row from table?
what is entry criteria for intigration testing,,? what is entry criteria for system testing? what is exit criteria for intigration testing & system testing??? plz give me proper examples .... thanks & regards svsekhar2003@gmail.com
what r all the testing methods & what methods u r using 4 the current project.
what is volume Testing?