PostgreSQL

NOT IN condition in PostgreSQL

by

PostgreSQL NOT IN To filter the results, the PostgreSQL NOT IN condition is used with SELECT, INSERT, UPDATE and DELETE statements to negate the IN conditions. Syntax: WHERE expressions NOT IN (value1, value2, …. value_n); Parameters: expressions: It is used to specify a column or a field. value_1, value_2… value_n: They are used to specify … Read more

IN condition in PostgreSQL

by

PostgreSQL IN To filter the results, the PostgreSQL IN condition is used with SELECT, INSERT, UPDATE and DELETE statements to replace the use of multiple OR conditions. Syntax: WHERE expressions IN (value1, value2, …. value_n); Parameters: expressions: It is used to specify a column or a field. value_1, value_2… value_n: They are used to specify … Read more

LIKE condition in PostgreSQL

by

PostgreSQL LIKE To filter the results, the PostgreSQL LIKE condition is used with a combination of WHERE Clause in SELECT, INSERT, UPDATE and DELETE statements to perform pattern matching. Syntax: WHERE expressions LIKE pattern [ ESCAPE ‘escape_character’ ] Parameters: expressions: It is used to specify a column or a field. pattern: It is used to … Read more

NOT condition in PostgreSQL

by

PostgreSQL NOT To filter the results, the PostgreSQL NOT condition is used with SELECT, INSERT, UPDATE and DELETE statements to negate a condition. Syntax: NOT condition; Parameters: condition: It is used to specify the conditions to negate. Example: Using NOT with LIKE condition. Students table: ID NAME AGE 1 Joy 5 2 Smiley 13 3 … Read more

AND OR condition in PostgreSQL

by

PostgreSQL AND OR To filter the results, the PostgreSQL AND and OR conditions can also be used in combination with SELECT, INSERT, UPDATE and DELETE statements to test more than one conditions. Syntax: WHERE condition_1 AND condition_2 .. OR condition_n; Parameters: condition_1, condition_2… condition_n: They are used to specify the conditions to be strictly followed … Read more

OR condition in PostgreSQL

by

PostgreSQL OR To filter the results, the PostgreSQL OR condition is used with SELECT, INSERT, UPDATE and DELETE statements to satisfy either of the conditions. Syntax: WHERE condition_1 OR condition_2 OR condition_3 …. OR condition_n; Parameters: condition_1, condition_2… condition_n: They are used to specify the conditions to be strictly followed for selection. Example: Students table: … Read more

AND condition in PostgreSQL

by

PostgreSQL AND To filter the results, the PostgreSQL AND condition is used with SELECT, INSERT, UPDATE and DELETE statements to test more than one conditions. Syntax: WHERE condition_1 AND condition_2 AND condition_3 …. AND condition_n; Parameters: condition_1, condition_2… condition_n: They are used to specify the conditions to be strictly followed for selection. Example: Students table: … Read more

PostgreSQL Conditions

by

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.   CONDITION USES AND When 2 or more conditions to be met. OR When any one of the conditions are met. AND … Read more

HAVING clause in PostgreSQL

by

PostgreSQL HAVING PostgreSQL HAVING clause is used to return the groups of rows only when the condition is TRUE. It is used with the PostgreSQL GROUP BY Clause. It, however, does not have a mandatory existence with the PostgreSQL GROUP BY Clause. Syntax: To group the rows by values in multiple columns. SELECT expressions FROM … Read more

GROUP BY in PostgreSQL

by

PostgreSQL GROUP BY PostgreSQL GROUP BY clause is used to collect data from multiple records and then to group the identical or similar results. It is used with the PostgreSQL SELECT statement. It, however, does not have a mandatory existence with the PostgreSQL SELECT statement. Syntax: To group the rows by values in multiple columns. … Read more