Answer Posted / 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 |
Post New Answer View All Answers
How can you do the usability testing?
i have done B.E. computer in 2009 i have done software testing course and also 6 months exp in testing on live project as trainee, now a days i am searching job in pune. can any one tell me any opening in pune?
What is mean by incident logging system ?
what is meant by application server and its functions?
how is market for testing in banglore,chennai,pune,delhi?
How do u go about testing of web application?
What is internationalization testing (i18n testing)?
Can list out some disadvantages of manual testing?
What is Windows Test Technologies? Where i will get all information of it.
What is the difference between IE, Opera & Mozilla Firefox in web Testing and which brower will think that is much better?
What Is risk Based testing?
When we are recording in WinRunner and interact with the AUT, what does WinRunner do?
What is Bomb Testing?
Can anybody write the test cases for the following scenario. I want to create District. for that, District Code field, District Name field, Reset button, Submit button, Back button are there in the screen. whenever we enter District Code & District Name in the related fields, by clicking on Submit button, District should be created. By clicking on Reset button, all fieds should be cleared. By clicking on Back button, user should navigate to home page. Can you write the test cases for the scenario. I want to know the test case format for the scenario. what procedure is the best. tahnks in advance...
Tell some examples of bug severity and bug priority?