He has given table attributes-
empid,empfirstname,emplastname,MangerID.And he asked write
query to display empfirstname and mangername?
Answer Posted / 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 |
Post New Answer View All Answers
can someone give me a brief idea about embedded testing.. i know both embedded system concepts and testing concepts.. i just want to know what we have to do for embedded testing
What are cookies?
How to explain the Insurance project in the interview?
Write notes on apparel testing equipments.
Write UI Test case, Integration Test case, Functional Test case & Performance Test case for the File Menu for MS-Word?
please give information about ERP Projects and how V-model use in project
Hi, Can anyone suggest a test case writing technique for the below scenario. 1. User draws a lines on the image 2. User selects the lines and right clicks ( Measuremnts like distance between the start and the end point, coordinates of start point and coordinates of end point) 3. User selects one of the measurement Measurement is displayed Just want to highlight, i am looking for a test case writing technique for above scenario.
Is Anyone attended the manual testing interview with capgemini in recent past. please let me know the type of questions they can ask. Thanks
what is scrum how with ex?
Difference between Re-testing and Regression testing?
what is mean by impact analysis ,how we used to select regression TC using this?
Can you explain usability testing?
What is meant by Boundary value analisis and Equalence partitioning? Can give derive this using these methods? In a system designed to work out the tax to be paid: An employee has £4000 of salary tax free. The next £1500 is taxed at 10% The next £28000 is taxed at 22% Any further amount is taxed at 40% Which of these groups of numbers would fall into the same equivalence class? a) £4800; £14000; £28000 b) £5200; £5500; £28000 c) £28001; £32000; £35000 d) £5800; £28000; £32000
Hi, I was asked following question during a interview. Please answer it: Password field is there,we can accepts every character except underscore and semicolon. It can accept min 6 characters and maximum 12 characters. Prepare boundary value and equivalence class test cases.
What do you understand by usability testing?