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 |
1) In a software development project Spiral Model was Chosen as the development model. What is the best-suited reason for this? A)This model is the oldest and most widely used paradigm for software development. B)In this model users get the feel free the actual system and developers get to build something immediately. C)In this model risk analysis is done coupled with evolutionary S/W process model with the iterative nature of prototyping and controlled systematic aspects of water fall model D)This model combines elements of Classical model with this iterative philoophy of prototyping.
Give an example for Waterfall model and iteration model??
how do you manage the testing for enhancement projects
what are the different banking terms used in your project?like new acc,dormate,active accounts....
does anybody have requirement document for any project? if u have , could u plz forward it to my mail brahma412@yahoo.co.in
Manual Testing Career Consultant - manualtestingtraing@gmail.com
hi.... plz tell me what all kinds of documents/reports are required for manual testing of a simple website(simple static pages). in a organization.
2 Answers HCL, IBM, iPRO Solutions,
How many maximum tables we can join by using SQL JOIN??
What is the diff bet test scenario and test case.
i have 500 testcases there,how to perform the Regression testin nad retesting?
If there is a button called Edit button. 1) Editing can be done by double clicking the object 2) Editing can be done by pressing Edit button 3) Editing can be done by pressing Alt+E key Then Should I have to write 3 different test cases for editing object? What should I do so that I 'll not miss the any functionality while testing.
Hi, Can anybody tell me what is Boundary value analysis, equivalence partitioning and error guessing with examples?