PostgreSQL: Clauses and filters
Clauses and filters: Like clause:
|
1 2 3 4 5 6 7 |
college=# select * from report where temp_hi:: text like '4%'; place | temp_lo | temp_hi | date | humidity | precp ----------------------------------------------------------- VZG | 32 | 43 | 2023-05-10 | 21 | HYD | 32 | 43 | 2020-07-19 | 24 | BZA | 32 | 43 | 2023-05-09 | 23 | (3 rows) |
LIMIT Clause: The LIMIT clause is used to restrict the number of rows returned in the result set. It is useful when you want to retrieve only a certain number of rows.
|
1 2 3 4 5 6 7 8 |
college=# select * from report LIMIT 4; place | temp_lo | temp_hi | date | humidity | precp ----------------------------------------------------------- VZG | 32 | 43 | 2023-05-10 | 21 | HYD | 32 | 43 | 2020-07-19 | 24 | BZA | 32 | 43 | 2023-05-09 | 23 | Delhi | 23 | 34 | 2023-05-15 | 24 | (4 rows) |
OFFSET Clause: It is used in conjunction… Read More
