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

Question

For example:

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

Is there a way to return blake?

I want to know who was treasurer between the two terms of jake.

It's not clear what you want. Can you give a bit more explanation and a few more examples to clarify? — Mark Byers
– Mark Byers, Commented Feb 6, 2011 at 9:20
Duplicate of stackoverflow.com/questions/4912293/… Maybe you two are in the same classroom. — Mike Sherrill 'Cat Recall'
– Mike Sherrill 'Cat Recall', Commented Feb 6, 2011 at 9:27
this is a different question because it has a different criteria. — diesel
– diesel, Commented Feb 6, 2011 at 9:30

Andomar · Accepted Answer · 2011-02-06 09:23:09Z

2

You could use between, like:

select  yt.name
from    YourTable yt
where   TheYear between yt.startyear and yt.endyear

between is inclusive, so this would return Blake for TheYear = 97 and 98.

answered Feb 6, 2011 at 9:23

Andomar

239k55 gold badges387 silver badges412 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

user330315 · Accepted Answer · 2011-02-06 09:57:37Z

2

Without more information, this is the best suggestion I can give:

SELECT name 
FROM your_table
WHERE startyear > (SELECT min(endyear) FROM your_table WHERE name = 'jake')
  AND endyear   < (SELECT max(startyear) FROM your_table WHERE name = 'jake')

answered Feb 6, 2011 at 9:57

user330315

Collectives™ on Stack Overflow

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

2 Answers 2

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related