self join query in sql.
15 objective questions.
What is equi join and outer join
- 2 Answers
- 8652 Views
- Bally Technologies, I also Faced
- E-Mail Answers
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
What is quality center? How many built in tables does quality center have?
What are the different ways of doing black box testing?
What is PBX Testing & What is Test coverage?
Why would we not include these?
hi i want manual testing interview question(3+exp)please tell me
Write a Test scenario for Outlook Search functionality.
What are all the scenario for 1.google analytics 2.api 3.paypal
what is acid testing?
how to test a web application manually?can u explain indetail?
Tell me agile process in your company
why use caffine for HPLC calibration ?
What are the disadvantages of manual testing?
Can any one explain me about hybrid integration testing? and what is interface in integration testing? thanks in advance...... regards, MurthySharma.Manchella
What type of projects can include in Logistics Domain? and what is the type of domain for project which include Driving license renewal, Different type of title registration etc...
You have a testing team of 10 members, and now you have to reduce it by 5 member and you dont want to increase risk in your product, you are try to cover all functionality to test. What test Strategy you follow.
