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
what s test block ratio? please any one answer me..
can you tell me how to write test cases for payments, receipts, inward clearing, outward clearing, A/c statements ?
how will u create diff types of scenario for any website?
What are the different types of integration testing?
What knowledge I must have as a 3 yrs. manual tester??
What’s the difference between a bug and a defect?
What is bug priority?
i have source and target having same data structure 500 fields and one lacks records. how to validate data. write 5 scenarios.
What is mean by Schedule report who is the responsible for generated that one ?
what is localization and globalization.and what are the ways way are going to test the particular application?how can we identify factual, visual, corrupted characters, link errors, formatting errors, etc in locallization?iam going to attend the interview on localization concepts and languages like : German, Japanese, French, Russian, Italian, Chinese, Korean, Portuguese and Spanish .tell me the process how to do testing above concepts let me know its urgent:anilaluvala@gmail.com 9908814046
Hi I am searching job please send some details abuot ERP project and real time test plan,traceability report,test case if any relate to erp project Please help me out to get a job in testing.my email address is chiku_69@yahoo.in Thank u
What type of questions will be asking for 2 years experience candidate in manual testing?
What are the main key components in web applications and client and server applications? And explain the differences between them?
Can you explain a pair-wise defect?
What are the qualities needed by a software tester?