You can use outer join to get the leftovers where as self join is used to compare a table with itself. In self join we consider the same table as two tables bearing the alies names
Type: Posts; User: csbhaskar; Keyword(s):
You can use outer join to get the leftovers where as self join is used to compare a table with itself. In self join we consider the same table as two tables bearing the alies names
the position of a column in an oracle table does not carry much value. The only problem is while selecting the columns with * the order will be not the desired one. however, this is till not solved...
are you asking for a minimum of two employees having the same address?