Database Management System Keys

Concept of database keys: Before understanding the concept of keys we must know what is a table. In a relational database a collection of similar entities can be called a table. Now, what is an entity; anything which has some attributes and those can be used t… Read more

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