Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

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


Please Help Members By Posting Answers For Below Questions

Write UI Test case, Integration Test case, Functional Test case & Performance Test case for the File Menu for MS-Word?

2663


plz tell me the difference b/w PB/MF based appl.with examples. Thanks

2231


How to do integration testing on duster......

1743


Hi, My name is Dinesh.I want to prepare for ISTQB certification , So can anyone please email me the syllabus of it and what is criteria for giving exam.Please email me answers at: dinesh0323@live.com

5193


Can some one help me writing a manual test case for email applications like yahoo i need for www.everonn.com

2002


What are the benefits of requirement traceability?

1172


What are the different available models of sdlc?

1139


iam new testing, i want improve writing test cases and bug defect etc? any on give suggestion pls?

1981


Why should you care about objects and object-oriented testing?

2380


Password is having 6 digit alphanumeric then what are the possible input conditions?

1186


What are the properties of a good requirement?

2042


in an online banking software,users are connecting to bankserver by login.This login module can take below inputs for user. a/c number prefix-3 digits but doesnot start with 0&1 a/c number sufix-6 digits number password-5to 10 chars alphanumerics in lowercase areacode-3 digits number but optional purpose- cheque deposit money trasfer mini statement bills pay After filling above fields,user can click submit button to connect to bank server.prepare test scenarios for online banking s/w login.

2012


What are bug leakage and bug release?

1252


Anyone attended the manual testing interview with L&T infotech in recent past. please let me know the type of questions they can ask especially in PM round. Thanks

10999


Katari your questions was really helpful could you please send the questions and answers with them . Can anyone sends the top 30-40 question and answers for the interview purposes

1839