self join query in sql.
15 objective questions.
What is equi join and outer join
Answer Posted / latha
self join:one physical table is divided into two logical tables and perform join operation on that tables.
query:
select a.eno,a.ename,b.ename as manager name from emp a,emp b where a.manager num=b.eno
equi join:perform join operations on matching columns on both the tables
| Is This Answer Correct ? | 1 Yes | 1 No |
Post New Answer View All Answers
Can you please provide me the standard testcase review templete and Test plan templete.In my company we are not following any Standards templete so.Please guve me some Excell attachments.
What are the qualities needed by a software tester?
can somebody plz tel me about financial domain for manual tester?? which kind of application use and what is the approach of testing??
What is the difference between pilot and beta testing?
State a generalized process for load test? Or explain how you did it previously.
what is diffrence between dynamic black box testing and dynamic white box testing
What is the main use of preparing traceability matrix and explain the real time usage?
I have an UI issue "please fill out this field" pop up in firefox browser keeps scrolling with the page is it valid???
Can anyone tell me, What is wound fixing?
what is entry and exit criteria and explain it?
What is Dynamic Binding and Dynamic Loss?
send the senario template
Can you explain random/monkey testing?
What is Catapult Testing in E-Learning Domain?
Diffrence b/w functional testing,functionality testing,system testing?