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
Write UI Test case, Integration Test case, Functional Test case & Performance Test case for the File Menu for MS-Word?
plz tell me the difference b/w PB/MF based appl.with examples. Thanks
How to do integration testing on duster......
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
Can some one help me writing a manual test case for email applications like yahoo i need for www.everonn.com
What are the benefits of requirement traceability?
What are the different available models of sdlc?
iam new testing, i want improve writing test cases and bug defect etc? any on give suggestion pls?
Why should you care about objects and object-oriented testing?
Password is having 6 digit alphanumeric then what are the possible input conditions?
What are the properties of a good requirement?
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.
What are bug leakage and bug release?
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
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