Follow Our FB Page << CircleMedia.in >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...

Difference between IN and EXISTS

Answer Posted / anju saxena

The EXISTS operator tests whether a given set is empty or
not. An exist operator on empty set returns False while on
nonempty set it returns True.
IN operator is used where membership of the element has to
tested against the set.

Is This Answer Correct ?    8 Yes 4 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What do you mean by stored procedures?

347


Why is partition used in sql?

329


Can we use rowid as primary key?

300


What is an inconsistent dependency?

350


Can we declare a column having number data type and its scale is larger than pricesionex: column_name number(10,100),column_name numbaer(10,-84)

345






What are stored procedures in mysql?

354


How to run sql statements through the web interface?

352


Can we alter stored procedure?

344


What is the difference between a query and a report?

332


What is procedure in pl sql?

328


Explain exception handling in pl/sql?

338


What is the difference between left and left outer join?

300


How many primary keys can a table have?

317


Can a foreign key have a different name?

314


How to add a column ‘salary’ to a table employee_details?

371