Interested to Buy Any Domain ? << Click Here >> for more details...
He has given table attributes-
empid,empfirstname,emplastname,MangerID.And he asked write
query to display empfirstname and mangername?
- 3 Answers
- 8593 Views
- Cap Gemini, I also Faced
- E-Mail Answers
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 |
Write max. no of test case's in following scenario Developer develops single page which consist of simple Text box and a Submit button. Developer has not written a single line of code for the button (i.e. no relation of Text box and Submit button). No validations are implemented on Test box as well as button.
IN TEST PLAN DOC, WHAT R THE ASUUMPTIONS MADE BY BY THE TEST ENG?
will any real time user send me any dummy r real time copy of traceability matrix. ref_it_ref@yahoo.co.in
Real-time applications add a new and potentially difficult element to the testing mix Option 1 performance Option 2 reliability Option 3 security
Give Proper Example for following situations 1. Sevirity 'Low' Priority 'Urgent' 2. Sevirity 'Urgent' Priority 'Low' 3. Sevirity 'Urgent' Priority 'Urgent' ? Also explain what is sevirity & Priority if A Printer suppose to print out 1000 Print outs for 1 refill of cartage But actually it is taking 1100?
Should every business test its software the same way?
how to verify a button size (e.g Login Button) on a web page have same dimension prescribed by Client in UI Testing..??
Difference between the HotFix,ShowStopper and critical bug?
can anybody give me an example for high severity and low priority?
What is Facet Testing?
what is traceability matrix?
What can you tell about the project if during testing you found 80 bugs in it? or What is the V-Model Development Method and do you agree with this model?
Automation Testing 
