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 |
hi this is chik here iam showing my current project ERP and am prepair in hr model please tell me details about it and what all function test in hr model and give me some test caserelated to this module.Please tell me am faceing lots of problem in interview am not able to explain in interview please help me out my id is chiku_69@yahoo.in
What are the fields of Tracebility Matrix?
What is the difference between Unit Testing and Debugging?
What is Black Phase in SDLC?
What is quality center?
What is client server application testing?
How to perform Regression testing manually?
what is field tests and laboratory tests in black box testing ?
What is Ur Streght?(In P.M)
12 Answers L&T, MBT,
Please answer it:Your achivements as an manual tester? Dont answer :Ive found bugs? Bcoz it is your job.
What kind of input do we need from the end user to begin proper testing?
What is risk analysis and what kind of risk you foud while testing