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
Hi ALl, Can you please list out Q & A for Test Lead,which Interviewer may ask in interview for Test Lead position
What is the difference between static testing and dynamic testing?
Hi,friends i am going to write ICST certificate exam on augest.So can anybody post some of sample qusetions for ICST certificate exam.Really it will be useful for me
What is the test harness?
How can you do the scalability testing?
can anybody send the project you have tested with the clear descriptions,and recent bugs u found in that
How much the bug is affecting the functionality of the application?
What is user acceptance testing (uat)?
What is a maturity level?
Can anyone write test cases on google account creation page in the testing template format , urgent pls and explain if possible how to execute also
What do you like about computers?
Can you explain function points?
Upps..., sorry my email id is this : preet405p@yahoo.com Thanks in advanced.
How to explain the Insurance project in the interview?
how to test ecg machine?