Exists clause: –

Exists clause: - The exists clause is used for testing whether the given set is empty or not. Exists on empty set return false while on non-empty set it returns true. The exists clause is used with where condition. An example of exists clause is –                 Select emp1.ename from employee emp1 where exists(select emp2.city... Continue Reading →

Advertisements

In clause: –

In clause: - The in clause is used where membership of the element has to be tested again the set. It can be used only in where condition because it returns either true or false. The in clause is also used when a condition is given with reference to another table. An example of in... Continue Reading →

Create a website or blog at WordPress.com

Up ↑

%d bloggers like this: