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 are the different strategies for rollout to end users?
Hi could some one please send me the testplan testcases(for 2Modules) and testscripts for mercry fliht aplication or gmail. please write those on templates and send me.In testplan plase write Testobjective, test scope, est approach, exlusions assumptios.
Assume a login page, and you have written 10 cases(say for example). How will you justify that these 10 testcase suffient for the login and how do you say this is 100% satisfies the need.
How will you prepare traceability matrix if there is no Business Doc and Functional Doc?
Explain the importance of agile testing?
wat if fiddler and how it is used in tesing an application. please explain with a real time scenario
In which all places, testing is done?One is from the server by calling server name.Can u suggest others?
can anyone tell anyone is providing training for CSTE exam in bangalore? and can u send some links related to this?
What about manual testing opening in bangalore in September. Not getting a single interview call from last one month.
Test Cases For Router&Switch
What are tools of performance testing?
What is the difference between system testing and integration testing?
Explain some techniques for developing software components with respect to testability.
What are the advantages of automation over manual testing?
what are your thoughts on SPRINT duration