self join query in sql.
15 objective questions.
What is equi join and outer join
- 2 Answers
- 9922 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
Have you worked in UDAP (Credit Card act 2009) project?What did you test in Billing & Payment modules?
i want to for technical interview question paper along with in tesrviwe Phases i need
tell me some major and minor defects in ur net banking project?
What is the big deal about ‘requirements’?
What is the difference between baseline and traceability matrix?
Is anybody have the telecom systems test cases from start to end?
Which is the best testing model?
When will the testing starts?
Hello, I want to know how to write a regression test plan? Can someone please send me the format/template? Thanks in advance
What is the difference between GUI Testing,UI testing and Usability TEsting
could u pls anyone tel me .."which is the best instute that provides eficient practical knowledge and also real-time oriented knowldge to do a project in manual and automation testing..in hyd" pls send me to dis mail-id if u find any..? sinducute17@gmail.com
can anyone help me in getting unix on manual testing i.e can u forward material & web sites to my mail id (suresh_57599@yahoo.com) to understand how the work flow working on manual testing on unix and the contents.plzzzzzzzz help me its urgent.
What kind of testing to be done in client server application and web application? Explain
Write down ten test cases for below scenario: Increase the day by 1 and date format should be mm/dd/yyyy Conditions are : date should not be greater then 31 and date<1 month should not be greater then 12 and month<1 year should not be greater then 10000 and year<1 Thanks in advance
1.what kind of testing have you done ?
