Home » SQL & PL/SQL » SQL & PL/SQL » Inner Join Record Count (Oracle 10g)
Inner Join Record Count [message #573193] Mon, 24 December 2012 00:21 Go to next message
vino06cse57
Messages: 131
Registered: July 2011
Location: chennai
Senior Member
What is the maximum number of rows that is possible to be produced by inner joining two tables having N and M (M < N) number of records on a non-prime column?

Re: Inner Join Record Count [message #573201 is a reply to message #573193] Mon, 24 December 2012 02:21 Go to previous messageGo to next message
Michel Cadot
Messages: 60062
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
We don't do homework.
So what is your answer and explain? Or if you don't know the answer, explain what is an inner join.

Regards
Michel
Re: Inner Join Record Count [message #573206 is a reply to message #573201] Mon, 24 December 2012 02:41 Go to previous messageGo to next message
vino06cse57
Messages: 131
Registered: July 2011
Location: chennai
Senior Member
I need to know the Maximum possible records retreived through Inner Join..
Re: Inner Join Record Count [message #573208 is a reply to message #573206] Mon, 24 December 2012 02:54 Go to previous message
Michel Cadot
Messages: 60062
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
We need you do your homework by yourself, answer my questions.

Regards
Michel
Previous Topic: pass multiple values as single input parameter into pipelined function
Next Topic: Transferring data from one DB to another DB
Goto Forum:
  


Current Time: Fri Dec 26 18:59:50 CST 2014

Total time taken to generate the page: 0.07241 seconds