He has given table attributes-
empid,empfirstname,emplastname,MangerID.And he asked write
query to display empfirstname and mangername?
Answers were Sorted based on User's Feedback
Answer / naveen kamatam
select a.employee_id,a.first_name,a.manager_id,b.first_name
from test a inner join test b
on a.manager_id=b.employee_id order by 1
Is This Answer Correct ? | 4 Yes | 0 No |
Answer / nandini p
For that you can use self join.
With in organization you will get manager name and their
mangers name, entire chain if you know the mangerid.
Is This Answer Correct ? | 1 Yes | 0 No |
Answer / sneha.va
Suppose 2 tables;
Employee : having columns
empid,empfirstname,emplastname,MangerID
Manager : ManagerID, Managername
SELECT A.EMPFIRSTNAME,B.MANAGERNAME FROM EMPLOYEE A INNER
JOIN MANAGER B
ON A.MangerID = B.MangerID
Is This Answer Correct ? | 3 Yes | 2 No |
can u define the usecase and testcase.
There are 2 options for Editing say Edit User. 1) Press Alt+E 2) Double click the user 3) Press Edit button Should I have to write 3 different cases for it?
Hello Friends,I want some clearence regarding. Test report and Final report.
say me any problem u faced in the project after delivering to client?
What is the difference between quality assurance and quality control?
What is sanity testing? and how to do sanity testing for a telephone
what is Softwar Audit?
Login page contains, Username , Password ,OK Button and CANCEL Button.If i click on OK button,cancel functionality is working and if i click on CANCEL Button,OK Functionality is working.In this case what is the level of priority (HIGH/MEDIUM/LOW) and level of SEVERIOTY (HIGH/MEDIUM/LOW)? Give the reason ,explain clearly?
EXPLAIN A SCENARIO AND FEW TEST CASES FOR COMPATABILITY TESTING?
how to report reviews
What is the initial stage of testing?
how will we receive the build?is it through mail or not?