PostgreSQL – LIKE Operator
LIKE operator is used in the WHERE clause to filter results by pattern matching. LIKE operator uses 2 wildcard options.
Continue readingPostgreSQL – IS NOT NULL
IS NOT NULL condition is used in the WHERE clause to identify records that have a value for the specified
Continue readingPostgreSQL – HAVING Clause
‘HAVING’ clause is used to filter results based on aggregate functions. It is used to filter the results that appear
Continue readingPostgreSQL – GROUP BY
GROUP BY clause is used in a SELECT statement to group “like” records. You can specify one or more columns
Continue readingPostgreSQL – IS NULL
IS NULL condition is used in the WHERE clause to identify records that do not have a value. Syntax: SELECT
Continue readingPostgreSQL – IN Operator
An ‘IN’ clause is used to specify 1 or more values in the WHERE clause. Syntax: SELECT * FROM table_name
Continue readingPostgreSQL – MIN Function
MIN function is an aggregate function that allows you to get the minimum of values. Example: Consider the employee table
Continue readingPostgreSQL – MAX Function
MAX function is an aggregate function that allows you to get the maximum of values. Example: Consider the employee table
Continue readingPostgreSQL – AVG (Average) Function
AVG function is an aggregate function that allows you to get the average of values. Example: Consider the employee table
Continue readingPostgreSQL – Adding days to Date
In Postgres, you can query today’s date as below: SELECT current_date; To get tomorrow’s date, simply add 1 day to
Continue reading