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
I know functional test cases are derived from frs and system design specs. But are test cases for performance, database, boundary, relational integrity and other types of tests other than functional tests created from frs and system design specs as well? When are these test cases created? Are they in the same test plans alongside functional test cases or is their a different test plan that includes these test cases?
what is the impact analysis?
What and why is api testing?
What are the differences between stlc and sdlc?
What is un-installation testing?
What is the Difference between Network testing and Web Testing?
what type of quetion may be asked for experienced person in manual tester of 1 year?
hi this is satish can some one help me out by sending the maxium notes on client sesrver ,web server and company architechture project hirearchy and company hirearchy i will happy to recive the answers as early as possible
How to do security implementation for any URL??
what is the common in all s.o.p (standaed operating procedure)?
Discuss what test metrics you feel are important to publish an organization?
What is the Diff between Code Walkthrough & Code Review? What is the diff between walkthrough and inspection? What is meant by GUI Testing?
what is the challenging position faced in the testing not in point of management point of view it must be in the point of while testing the application?
what is difference between win 98 and win 2000 poertating system?which is better one?
How can you define state tanstion testing aswell decesion testing with examples.how you can differ them too??