| SQL Non Equi Join [message #395889] |
Fri, 03 April 2009 00:14  |
ygsunilkumar
Messages: 100
Registered: August 2008
|
Senior Member |
|
|
|
what are other operators allowed in the Non EquiJoins except these operators (<=, >=, BETWEEN)? It is an Interview Question.
|
|
|
|
| Re: SQL Non Equi Join [message #395894 is a reply to message #395889] |
Fri, 03 April 2009 00:25  |
Frank
Messages: 7901
Registered: March 2000
|
Senior Member |
|
|
IN, =, <, > are the first that come to my mind.
That is, after it came to my mind that the need to be able to sum up a complete list of operators is BS. I think the ability to explain what an equijoin is (or a non-equijoin) would be far more important.
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Re: SQL Non Equi Join [message #396870 is a reply to message #395889] |
Wed, 08 April 2009 04:09 |
flyboy
Messages: 1903
Registered: November 2006
|
Senior Member |
|
|
| ygsunilkumar wrote on Fri, 03 April 2009 07:14 | what are other operators allowed in the Non EquiJoins except these operators (<=, >=, BETWEEN)? It is an Interview Question.
|
In my opinion, the easiest way to get this is:
Firstly, determine, which operator is used in equijoin.
Secondly, list all operators. As all the examples you listed are used in conditions, it is possible to find the rest of them in the Conditions chapter of SQL Reference. This documentation book is available e.g. online on http://tahiti.oracle.com/. Or, in an interview, you should ask the examiner what exactly he assumes to be an "operator".
Anyway, the last part is quite obvious.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
