2 CREATE TABLE t1(f1 TINYINT,f2 SMALLINT,f3 INT,f4 BIGINT,f5 CHAR(20),f6 VARCHAR(30),f7 FLOAT,f8 DOUBLE,f9 DATE,f10 TIME,f11 TIMESTAMP);
5 f1=1 | f2(=11 | f3=111 | f4=1111 | f5=CSQL1 | f6=LAKSHYA1 | f7=11.000000 | f8=1111.000000 | f9=2001-01-01 | f10=01:01:01 | f11=2001-1-1 1:1:1 |
6 f1=2 | f2(=22 | f3=222 | f4=2222 | f5=CSQL2 | f6=LAKSHYA2 | f7=22.000000 | f8=2222.000000 | f9=2002-02-02 | f10=02:02:02 | f11=2002-2-2 2:2:2 |
7 f1=3 | f2(=33 | f3=333 | f4=3333 | f5=CSQL3 | f6=LAKSHYA3 | f7=33.000000 | f8=3333.000000 | f9=2003-03-03 | f10=03:03:03 | f11=2003-3-3 3:3:3 |
8 f1=4 | f2(=44 | f3=444 | f4=4444 | f5=CSQL4 | f6=LAKSHYA4 | f7=44.000000 | f8=4444.000000 | f9=2004-04-04 | f10=04:04:04 | f11=2004-4-4 4:4:4 |
9 f1=5 | f2(=55 | f3=555 | f4=5555 | f5=CSQL5 | f6=LAKSHYA5 | f7=55.000000 | f8=5555.000000 | f9=2005-05-05 | f10=05:05:05 | f11=2005-5-5 5:5:5 |
10 f1=6 | f2(=66 | f3=666 | f4=6666 | f5=CSQL6 | f6=LAKSHYA6 | f7=66.000000 | f8=6666.000000 | f9=2006-06-06 | f10=06:06:06 | f11=2006-6-6 6:6:6 |
11 f1=7 | f2(=77 | f3=777 | f4=7777 | f5=CSQL7 | f6=LAKSHYA7 | f7=77.000000 | f8=7777.000000 | f9=2007-07-07 | f10=07:07:07 | f11=2007-7-7 7:7:7 |
12 f1=8 | f2(=88 | f3=888 | f4=8888 | f5=CSQL8 | f6=LAKSHYA8 | f7=88.000000 | f8=8888.000000 | f9=2008-08-08 | f10=08:08:08 | f11=2008-8-8 8:8:8 |
13 f1=9 | f2(=99 | f3=999 | f4=9999 | f5=CSQL9 | f6=LAKSHYA9 | f7=99.000000 | f8=9999.000000 | f9=2009-09-09 | f10=09:09:09 | f11=2009-9-9 9:9:9 |
14 f1=10 | f2(=100 | f3=1000 | f4=10000 | f5=CSQL10 | f6=NULL | f7=100.000000 | f8=10000.000000 | f9=2010-10-10 | f10=10:10:10 | f11=2010-10-10 10:10:10 |
16 SELECT * FROM t1 WHERE f3=111;
17 f1=1 | f2=11 | f3=111 | f4=1111 | f5=CSQL1 | f6=LAKSHYA1 | f7=11.000000 | f8=1111.000000 | f9=2001-01-01 | f10=01:01:01 | f11=2001-1-1 1:1:1 |
19 SELECT * FROM t1 WHERE f4<3333;
20 f1=1 | f2=11 | f3=111 | f4=1111 | f5=CSQL5 | f6=LAKSHYA1 | f7=11.000000 | f8=1111.000000 | f9=2001-01-01 | f10=01:01:01 | f11=2001-1-1 1:1:1 |
21 f1=2 | f2=22 | f3=222 | f4=2222 | f5= CSQL2| f6=LAKSHYA2 | f7=22.000000 | f8=2222.000000 | f9=2002-02-02 | f10=02:02:02 | f11=2002-2-2 2:2:2 |
23 SELECT * FROM t1 WHERE f6<='LAKSHYA3';
24 f1=1 | f2=11 | f3=111 | f4=1111 | f5=CSQL1 | f6=LAKSHYA1 | f7=11.000000 | f8=1111.000000 | f9=2001-01-01 | f10=01:01:01 | f11=2001-1-1 1:1:1 |
25 f1=2 | f2=22 | f3=222 | f4=2222 | f5=CSQL2 | f6=LAKSHYA2 | f7=22.000000 | f8=2222.000000 | f9=2002-02-02 | f10=02:02:02 | f11=2002-2-2 2:2:2 |
26 f1=3 | f2=33 | f3=333 | f4=3333 | f5=CSQL3 | f6=LAKSHYA3 | f7=33.000000 | f8=3333.000000 | f9=2003-03-03 | f10=03:03:03 | f11=2003-3-3 3:3:3 |
28 SELECT * FROM t1 WHERE f9>'2008-08-08' and f10 <'10:10:10';
29 f1=9 | f2=99 | f3=999 | f4=9999 | f5=CSQL9 | f6=LAKSHYA9 | f7=99.000000 | f8=9999.000000 | f9=2009-09-09 | f10=09:09:09 | f11=2009-9-9 9:9:9 |
31 SELECT * FROM t1 WHERE f3 between 100 and 500;
32 f1=9 | f2(=99 | f3=999 | f4=9999 | f5=CSQL9 | f6=LAKSHYA9 | f7=99.000000 | f8=9999.000000 | f9=2009-09-09 | f10=09:09:09 | f11=2009-9-9 9:9:9 |
34 SELECT * FROM t1 WHERE f6 like '%_KSHYA5';
35 f1=5 | f2=55 | f3=555 | f4=5555 | f5=CSQL5 | f6=LAKSHYA5 | f7=55.000000 | f8=5555.000000 | f9=2005-05-05 | f10=05:05:05 | f11=2005-5-5 5:5:5 |
37 SELECT * FROM t1 WHERE f11 in ('2005-05-05 05:05:05','2006-06-06 06:06:06');
38 f1=5 | f2=55 | f3=555 | f4=5555 | f5=CSQL5 | f6=LAKSHYA5 | f7=55.000000 | f8=5555.000000 | f9=2005-05-05 | f10=05:05:05 | f11=2005-5-5 5:5:5 |
39 f1=6 | f2=66 | f3=666 | f4=6666 | f5=CSQL6 | f6=LAKSHYA6 | f7=66.000000 | f8=6666.000000 | f9=2006-06-06 | f10=06:06:06 | f11=2006-6-6 6:6:6 |
41 SELECT * FROM t1 WHERE f3 is NOT NULL and f4=7777;
42 f1=7 | f2=77 | f3=777 | f4=7777 | f5=CSQL7 | f6=LAKSHYA7 | f7=77.000000 | f8=7777.000000 | f9=2007-07-07 | f10=07:07:07 | f11=2007-7-7 7:7:7 |
44 SELECT * FROM t1 WHERE f6 is NULL or not(f4=8888);
45 f1=1 | f2=11 | f3=111 | f4=1111 | f5=CSQL1| f6=LAKSHYA1 | f7=11.000000 | f8=1111.000000 | f9=2001-01-01 | f10=01:01:01 | f11=2001-1-1 1:1:1 |
46 f1=2 | f2=22 | f3=222 | f4=2222 | f5=CSQL2 | f6=LAKSHYA2 | f7=22.000000 | f8=2222.000000 | f9=2002-02-02 | f10=02:02:02 | f11=2002-2-2 2:2:2 |
47 f1=3 | f2=33 | f3=333 | f4=3333 | f5=CSQL3 | f6=LAKSHYA3 | f7=33.000000 | f8=3333.000000 | f9=2003-03-03 | f10=03:03:03 | f11=2003-3-3 3:3:3 |
48 f1=4 | f2=44 | f3=444 | f4=4444 | f5=CSQL4 | f6=LAKSHYA4 | f7=44.000000 | f8=4444.000000 | f9=2004-04-04 | f10=04:04:04 | f11=2004-4-4 4:4:4 |
49 f1=5 | f2=55 | f3=555 | f4=5555 | f5=CSQL5 | f6=LAKSHYA5 | f7=55.000000 | f8=5555.000000 | f9=2005-05-05 | f10=05:05:05 | f11=2005-5-5 5:5:5 |
50 f1=6 | f2=66 | f3=666 | f4=6666 | f5=CSQL6 | f6=LAKSHYA6 | f7=66.000000 | f8=6666.000000 | f9=2006-06-06 | f10=06:06:06 | f11=2006-6-6 6:6:6 |
51 f1=7 | f2=77 | f3=777 | f4=7777 | f5=CSQL7 | f6=LAKSHYA7 | f7=77.000000 | f8=7777.000000 | f9=2007-07-07 | f10=07:07:07 | f11=2007-7-7 7:7:7 |
52 f1=9 | f2=99 | f3=999 | f4=9999 | f5=CSQL9 | f6=LAKSHYA9 | f7=99.000000 | f8=9999.000000 | f9=2009-09-09 | f10=09:09:09 | f11=2009-9-9 9:9:9 |
53 f1=10 | f2=100 | f3=1000 | f4=10000 | f5=CSQL10 | f6=NULL | f7=100.000000 | f8=10000.000000 | f9=2010-10-10 | f10=10:10:10 | f11=2010-10-10 10:10:10 |