Showing posts from April, 2020Show all

Anti join in oracle

Anti join : Anti join Principles of inner , outer joins revolve over the concept of selecting the matching records but if we need the opposite of this that is the records which do not have matching records then the concept of Anti join comes in the show. It is… Read more

SQL join | cross join, inner join, outer join

SQL join (cross join, inner join, outer join ) : Join is a binary operation that is used to combine data from two tables. We can combine more than two tables by joining them one after another. In a relational database mainly the relation between two tables is used … Read more