postgresql - How do i find out a value between two parameters in postgres sql? -

for example:

name | startyear | endyear  jon    2003       2005 jake   1999       2002 blake  1997       1998 jake   1995       1996 jason  1993       1994

is there way return blake?

i want know treasurer between 2 terms of jake.

you use between, like:

select  yt.name    yourtable yt   theyear between yt.startyear , yt.endyear

between inclusive, return blake theyear = 97 , 98.

Manage