diff b/w where n exists

[#1]

diff b/w where n exist

[#2]

see link

Where Exists
Not exists

Exits check the Existence of data in a field.

Where use for certain condition.

both are used simulteniously

like where Exits(fieldname)

example-

load

a,b

from table where a=5;