I have 5 session between two date table name ABC
| SESS-ID | DATE-1 | DATE-2 |
|---|---|---|
| 1 | 01-Mar-2001 | 30-Mar-2002 |
| 2 | 01-Mar-2003 | 30-Mar-2004 |
| 3 | 01-Mar-2005 | 30-Mar-2006 |
| 4 | 01-Mar-2007 | 30-Mar-2008 |
| 5 | 01-Mar-2009 | 30-Mar-2010 |
enter image description here
enter image description here
Kindly provide me with a query idea to retrieve the correct SESS-ID for the date 13-May-2002 in Oracle 11G.