wowDbase

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 ) : 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

In this blog we have tried to capture some scenario based sql queries or similar queries which are very frequently asked in many interviews. We have used oracle live sql for execution. At first we are creating a set of tables, which have been used in the followin… Read more