What is the EXISTS operator

0 votes
Hi!!

Can someone tell me what is the EXISTS Operator?
Dec 14, 2018 in Database by CodingByHeart77
• 3,720 points
143 views

1 answer to this question.

0 votes

Exists operator is used to test if a record exists or not.

Syntax:

SELECT column_name(s)
FROM table_name
WHERE EXISTS
(SELECT column_name FROM table_name WHERE condition);
answered Dec 14, 2018 by Sahiti
• 6,380 points

Related Questions In Database

0 votes
1 answer

What is the SQL query to get the third highest salary of an employee from employee_table

You can try out something like this: SELECT ...READ MORE

answered Sep 27, 2018 in Database by Sahiti
• 6,380 points
6,304 views
0 votes
1 answer

Which operator is used in the query for pattern matching?

LIKE operator is used for pattern matching, ...READ MORE

answered Oct 15, 2018 in Database by DataKing99
• 8,240 points
10,454 views
0 votes
1 answer

What is the need of MERGE statement?

This statement allows conditional update or insertion of ...READ MORE

answered Oct 23, 2018 in Database by DataKing99
• 8,240 points
177 views
0 votes
1 answer

Can someone tell me what is IS NULL operator

Since it is not possible to test ...READ MORE

answered Nov 20, 2018 in Database by DataKing99
• 8,240 points
129 views
0 votes
1 answer

Why is not preferable to use mysql_* functions in PHP?

The reasons are as follows: The MySQL extension: Does ...READ MORE

answered Sep 7, 2018 in Database by DataKing99
• 8,240 points
249 views
0 votes
1 answer

Find values in a comma separated string in a MySQL query

You can add commas to the left and ...READ MORE

answered Sep 10, 2018 in Database by Sahiti
• 6,380 points
10,615 views
0 votes
1 answer

How to do a batch insert in MySQL

You can try out the following query: INSERT ...READ MORE

answered Sep 10, 2018 in Database by Sahiti
• 6,380 points
1,522 views
0 votes
1 answer
+1 vote
1 answer

What is the AND operator?

The AND operator is used to filter ...READ MORE

answered Dec 1, 2018 in Database by Sahiti
• 6,380 points
202 views
0 votes
1 answer

What is the NOT Operator in MySQL?

NOT operator displays a record when the ...READ MORE

answered Dec 14, 2018 in Database by Sahiti
• 6,380 points
252 views