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 |
One very small question, If application/ website performing all the function perfectly like submission, deletion, editing etc, why do we require Data base testing saparately. Please understand before reply thanks !!
Hi friends This is sowmya plz can u tell me what type of questions will they ask in banking domain in interview plz let me know thanks in advance
I need a Test case templetes for Yahoo Mail ID
Expain testing proces of your company?
How do you manage your writen/modified/executed test cases, Bug report etc,without using any tool?
what r the different types of testing techniques?
what are the do's and dont's of a tester?
What is a traceability matrix, and what is the purpose of it?
what is the structure of test cases
What is Test Suite?
11 Answers Digient Technologies,
What is the initial stage of testing?
as a tester, do u know only ur module requirements or other module req's also?