self join query in sql.
15 objective questions.
What is equi join and outer join
- 2 Answers
- 9062 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
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
Tell me the advantage and disadvantage of cookies?
iam new testing, i want improve writing test cases and bug defect etc? any on give suggestion pls?
can we do database testing in manual testing? then how we write the test case?
There is an opening in our organization Sierra Atlantic, Hyderabad. All Manual test engineers with 2-3 years of experience can forward your resumes to mah_cs82@yahoo.com before May 01, 2008. (Only manual testers) with a covering letter, current CTC and Expected CTC.
What is performance tuning? What are tools of performance testing?
Easiest way to write test cases? How i can learn writing the test cases?
Hi Friends, Can anubody give me brief overview of Automation tools.. (basics of tools-summary)of following tools? 1.Qualty Center 2.Load Runner 3.Win Runner 4.Q.T.P mail me on ...rachna.huda@gmail.com
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.
online demo for bug tracker tool(let me know the website)
i have source and target having same data structure 500 fields and one lacks records. how to validate data. write 5 scenarios.
What is the Jar file?
Hi, Can anyone suggest a test case writing technique for the below scenario. 1. User draws a lines on the image 2. User selects the lines and right clicks ( Measuremnts like distance between the start and the end point, coordinates of start point and coordinates of end point) 3. User selects one of the measurement Measurement is displayed Just want to highlight, i am looking for a test case writing technique for above scenario.
wat are the questions would the project leader ask about the project?? please do send the answers early.
What are the cases why parameterization is necessary when load testing the Web server and the database server?
