Sir/Miss
if exist and if not exist ye vala mujhe samjha nahi. pls explain sir/miss
Suppose you have an apple, and you ask your friends A
and B
Do i have an ? (if exist
apple?)
your friend A replies YES(true boolean)
your friend B replies NO(false boolean)
But you know the truth answer is YES(true boolean)
Thus in sql
if exist = true returns at lease 1 row
if exist = false returns at no row
Suppose you do not have a football , and you ask your friends A
and B
Do not i have a ? (if not exist
football?)
your friend A replies YES(true boolean) = you have
your friend B replies NO(false boolean) = you do not have
But you know the truth answer is NO(false boolean)
Thus in sql
if not exist = true returns at no row
if not exist = false returns at lease 1 row
click like & happy coding