PostgreSQL Like The PostgreSQL LIKE is used to return rows if the operand matches a pattern in a select. Like syntax SELECT * FROM table_name WHERE column_name LIKE pattern; Like example Goods table id good_type name description price insert_date 1 A...
PostgreSQL Between The PostgreSQL BETWEEN returns rows between two values from a select query. Between syntax SELECT * FROM table_name WHERE column_name BETWEEN x_value AND y_value; Between example Goods table id good_type name description price insert_date 1 A Car_1 Car 1...
PostgreSQL And – Or AND returns query rows if both conditions are true. OR returns query rows if at least one of the conditions is true. And – Or syntax SELECT * FROM table_name WHERE condition AND condition; SELECT * FROM...
PostgreSQL Where The PostgreSQL WHERE clause is used to return records that meet the conditions in a select. Where syntax -- select the records that meet the condition SELECT * FROM table_name WHERE {condition} SELECT * FROM view_name WHERE {condition} SELECT...
PostgreSQL Distinct The PostgreSQL DISTINCT is used to eliminate duplicate records from a table or a query. Distinct syntax -- select distinct column records from table SELECT DISTINCT column_name FROM table_name -- select specific columns SELECT DISTINCT column_name1, column_name2 FROM table_name...