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
Hello everybody, How many people do you think one sprint team can have in average?
What is defect removable efficiency?
what are the tests u did in entire project? when it did in the project? (means at the release build to end of project) plz explain clearly
what is prototyping model,RAD model V model, spiral model?????
What are all the scenario for 1.google analytics 2.api 3.paypal
what type of testing techniques are using after accept the build?
date format and we should 8 digits - not accepted only /accepted write how many in test cases in the date format valid , and in valid
what is traceability matrix and its usefulness
Which is the best book to ref. for design the test cases/scenario in manual testing,which gives detailed idea with all the strategies ?
What is concurrent user hits in load testing?
Give the real-time example for back-to-back testing?
uses of checklist
How is ‘build’ different from ‘release’?
How can data caching have a negative effect on load testing results?
what should be tested when credit card is used as payment option in ecommerce project?can anyone tell me in detail what to test n how to test when credit card is involved in web application?