AWS bytes

LIKE operator is used in the WHERE clause to filter results by pattern matching. LIKE operator uses 2 wildcard options.

IS NOT NULL condition is used in the WHERE clause to identify records that have a value for the specified

‘HAVING’ clause is used to filter results based on aggregate functions. It is used to filter the results that appear

GROUP BY clause is used in a SELECT statement to group “like” records. You can specify one or more columns

IS NULL condition is used in the WHERE clause to identify records that do not have a value. Syntax: SELECT

An ‘IN’ clause is used to specify 1 or more values in the WHERE clause. Syntax: SELECT * FROM table_name

MIN function is an aggregate function that allows you to get the minimum of values. Example: Consider the employee table

MAX function is an aggregate function that allows you to get the maximum of values. Example: Consider the employee table

AVG function is an aggregate function that allows you to get the average of values. Example: Consider the employee table

In Postgres, you can query today’s date as below: SELECT current_date; To get tomorrow’s date, simply add 1 day to