3 Tuple value is
2008-03-21 0 Nihar0
4 Tuple value is
2009-11-10 1 Nihar1
5 Tuple value is
2008-03-24 2 Nihar2
6 Tuple value is
2009-11-10 3 Nihar3
7 Tuple value is
2008-03-21 4 Nihar4
8 Tuple value is
2009-11-10 5 Nihar5
10 SELECT
* FROM T1 where f1
= '2009-11-10';
12 Tuple value is
2009-11-10 1 Nihar1
13 Tuple value is
2009-11-10 3 Nihar3
14 Tuple value is
2009-11-10 5 Nihar5
16 SELECT
* FROM T1 where f2
>= ? and f3
<= ?
;
18 Tuple value is
2009-11-10 1 Nihar1
19 Tuple value is
2008-03-24 2 Nihar2
20 Tuple value is
2009-11-10 3 Nihar3
22 SELECT
* FROM T1 where f1
='2009-11-10' and f2
>= ? and f3
<= ?
;
24 Tuple value is
2009-11-10 1 Nihar1
25 Tuple value is
2009-11-10 3 Nihar3