Thursday , November 21 2024

Database Tutorials MSSQL, Oracle, PostgreSQL, MySQL, MariaDB, DB2, Sybase, Teradata, Big Data, NOSQL, MongoDB, Couchbase, Cassandra, Windows, Linux

How To Use Between Command On PostgreSQL

You can use the between command (including the first and last value) to read the data between the two values in the table in the database.

The syntax of the Between command and its usage are as follows.

SELECT * FROM your_table_name WHERE your_column_name BETWEEN 28056 AND 30000;

1	SELECT * FROM your_table_name WHERE your_column_name BETWEEN 28056 AND 30000;