SQL to select all rows where the value of a column is between a range

Question

I need an SQL query to select all rows from the concepts table with concept_codes between F01 and F99, including both. I am using the PostgreSQL database, so the syntax should be compatible with PostgreSQL.

Answer 1

To specify a range of values in SQL, you can use the BETWEEN clause. For example, if you want to retrieve all rows from the concepts table where the concept_code falls within the range of 'F01' to 'F99', you can use the following SQL query:

SELECT * FROM concepts

WHERE concept_code BETWEEN 'F01' AND 'F99';

This query will return all records from the concepts table where the concept_code is between 'F01' and 'F99'.