CodesJava

Easy learning with example program codes

PostgreSQL Conditions

Conditions in PostgreSQL are generally used with CRUD operations to retrieve more specific results. They are usually used with the WHERE clause. Below is the list of conditions facilitated by the PostgreSQL database.

 

CONDITIONUSES
ANDWhen 2 or more conditions to be met.
ORWhen any one of the conditions are met.
AND & ORWhen AND & OR both conditions are met.
LIKESimple pattern matching (wildcards) in a where clause.
INAs an alternative to multiple OR conditions.
NOT INTo negate the IN conditions.
NOTTo negate a condition.
BETWEENTo retrieve within a range (inclusive).

 

Please follow and like us:
error









Copyright © 2019 CodesJava DMCA.com Protection Status