1 ---------------------------------------------------------
2 t1.f1 t1.f2 t1.f3 t1.f4 t1.f5 t1.f6 t1.f7 t1.f8 t1.f9
3 ---------------------------------------------------------
4 1 2011 111111111 Govind
113.140999 111111111.111111 1915/12/25 11:42:35.0 1971/12/25 11:42:35.0
5 2 1978 222222222 Gopal
114.567001 222222222.222222 1926/5/16 12:32:14.0 1972/5/16 12:32:14.0
6 3 2008 333333333 kishor
122.699997 333333333.333333 1937/8/15 13:45:36.0 1973/8/15 13:45:36.0
7 4 1973 444444444 kiran
142.718002 444444444.444444 1946/12/25 14:42:35.0 1974/12/25 14:42:35.0
8 5 2005 555555555 ganesh
152.718002 555555555.555555 1955/12/25 15:42:35.0 1975/12/25 15:42:35.0
9 6 1962 666666666 suresh
162.718002 666666666.666666 1965/12/25 16:42:35.0 1976/12/25 16:42:35.0
10 7 1965 777777777 Praba
172.718002 777777777.777777 1975/12/25 17:42:35.0 1977/12/25 17:42:35.0
11 8 1942 888888888 karan
182.718002 888888888.888888 1985/12/25 18:42:35.0 1978/12/25 18:42:35.0
12 9 1956 999999999 sharan
192.718002 999999999.999999 1995/12/25 19:42:35.0 1979/12/25 19:42:35.0
13 10 1999 101010101 vijay
102.718002 111111111.999999 1915/12/25 20:42:35.0 1980/12/25 20:42:35.0
14 11 2010 121212121 Prasad
112.718002 111111111.222222 2005/12/25 21:42:35.0 2005/12/25 21:42:35.0
15 12 2069 131313131 jiten
122.718002 222222222.333333 2025/12/25 22:42:35.0 2025/12/25 22:42:35.0
16 13 1857 141414141 hiten
132.718002 333333333.444444 2035/12/25 23:42:35.0 2035/12/25 23:42:35.0
17 14 1545 151515151 methane
126.718002 444444444.555555 2045/12/25 0:42:35.0 2032/12/25 0:42:35.0
18 15 1889 161616161 ethane
211.718002 555555555.222222 2065/12/25 1:42:35.0 2005/12/25 1:42:35.0
19 16 1789 171717171 sanjay
222.718002 666666666.777777 2010/12/25 2:42:35.0 2010/12/25 2:42:35.0
20 17 2032 181818181 vikrant
233.718002 777777777.888888 2020/12/25 3:42:35.0 2020/12/25 3:42:35.0
21 18 2038 444455555 nishant
244.718002 888888888.999999 2040/12/25 4:42:35.0 2031/12/25 4:42:35.0
22 19 2048 777755555 Sushant
277.717987 333333333.999999 2023/12/25 5:42:35.0 2011/12/25 4:42:35.0
23 20 1994 666633333 vishnu
255.718002 333333333.666666 2030/12/25 6:42:35.0 2030/12/25 5:42:35.0
25 +---------------------------------------+
32 +---------------------------------------+
33 \e[?
1034hSQL
> select * from t1
;
34 +------+-----------+---------------------+-----------+---------------+-------------------------+-----------+---------+--------------------+
35 | f1 | f2 | f3 | f4 | f5 | f6 | f7 | f8 | f9 |
36 +------+-----------+---------------------+-----------+---------------+-------------------------+-----------+---------+--------------------+
37 |
1 |
2011 |
111111111 | Govind |
113.141 |
111111111.111111 |
1915-12-25|
11:42:35|
1971-12-25 11:42:35|
38 |
2 |
1978 |
222222222 | Gopal |
114.567 |
222222222.222222 |
1926-05-16|
12:32:14|
1972-05-16 12:32:14|
39 |
3 |
2008 |
333333333 | kishor |
122.7 |
333333333.333333 |
1937-08-15|
13:45:36|
1973-08-15 13:45:36|
40 |
4 |
1973 |
444444444 | kiran |
142.718 |
444444444.444444 |
1946-12-25|
14:42:35|
1974-12-25 14:42:35|
41 |
5 |
2005 |
555555555 | ganesh |
152.718 |
555555555.555555 |
1955-12-25|
15:42:35|
1975-12-25 15:42:35|
42 |
6 |
1962 |
666666666 | suresh |
162.718 |
666666666.666666 |
1965-12-25|
16:42:35|
1976-12-25 16:42:35|
43 |
7 |
1965 |
777777777 | Praba |
172.718 |
777777777.777777 |
1975-12-25|
17:42:35|
1977-12-25 17:42:35|
44 |
8 |
1942 |
888888888 | karan |
182.718 |
888888888.888888 |
1985-12-25|
18:42:35|
1978-12-25 18:42:35|
45 |
9 |
1956 |
999999999 | sharan |
192.718 |
999999999.999999 |
1995-12-25|
19:42:35|
1979-12-25 19:42:35|
46 |
10 |
1999 |
101010101 | vijay |
102.718 |
111111111.999999 |
1915-12-25|
20:42:35|
1980-12-25 20:42:35|
47 |
11 |
2010 |
121212121 | Prasad |
112.718 |
111111111.222222 |
2005-12-25|
21:42:35|
2005-12-25 21:42:35|
48 |
12 |
2069 |
131313131 | jiten |
122.718 |
222222222.333333 |
2025-12-25|
22:42:35|
2025-12-25 22:42:35|
49 |
13 |
1857 |
141414141 | hiten |
132.718 |
333333333.444444 |
2035-12-25|
23:42:35|
2035-12-25 23:42:35|
50 |
14 |
1545 |
151515151 | methane |
126.718 |
444444444.555555 |
2045-12-25|
00:42:35|
2032-12-25 00:42:35|
51 |
15 |
1889 |
161616161 | ethane |
211.718 |
555555555.222222 |
2065-12-25|
01:42:35|
2005-12-25 01:42:35|
52 |
16 |
1789 |
171717171 | sanjay |
222.718 |
666666666.777777 |
2010-12-25|
02:42:35|
2010-12-25 02:42:35|
53 |
17 |
2032 |
181818181 | vikrant |
233.718 |
777777777.888888 |
2020-12-25|
03:42:35|
2020-12-25 03:42:35|
54 |
18 |
2038 |
444455555 | nishant |
244.718 |
888888888.999999 |
2040-12-25|
04:42:35|
2031-12-25 04:42:35|
55 |
19 |
2048 |
777755555 | Sushant |
277.718 |
333333333.999999 |
2023-12-25|
05:42:35|
2011-12-25 04:42:35|
56 |
20 |
1994 |
666633333 | vishnu |
255.718 |
333333333.666666 |
2030-12-25|
06:42:35|
2030-12-25 05:42:35|
57 +------+-----------+---------------------+-----------+---------------+-------------------------+-----------+---------+--------------------+
58 SQLRowCount returns
20
60 SQL
> ---------------------------------------------------------
61 t1.f1 t1.f2 t1.f3 t1.f4 t1.f5 t1.f6 t1.f7 t1.f8 t1.f9
62 ---------------------------------------------------------
63 1 2011 111111111 Govind
113.140999 111111111.111111 1915/12/25 11:42:35.0 1971/12/25 11:42:35.0
64 5 2005 555555555 ganesh
152.718002 555555555.555555 1955/12/25 15:42:35.0 1975/12/25 15:42:35.0
65 10 1999 101010101 vijay
102.718002 111111111.999999 1915/12/25 20:42:35.0 1980/12/25 20:42:35.0
66 15 1889 161616161 ethane
211.718002 555555555.222222 2065/12/25 1:42:35.0 2005/12/25 1:42:35.0
67 20 1994 666633333 vishnu
255.718002 333333333.666666 2030/12/25 6:42:35.0 2030/12/25 5:42:35.0
69 ---------------------------------------------------------
70 t1.f1 t1.f2 t1.f3 t1.f4 t1.f5 t1.f6 t1.f7 t1.f8 t1.f9
71 ---------------------------------------------------------
72 7 1965 777777777 Praba
172.718002 777777777.777777 1975/12/25 17:42:35.0 1977/12/25 17:42:35.0
73 8 1942 888888888 karan
182.718002 888888888.888888 1985/12/25 18:42:35.0 1978/12/25 18:42:35.0
74 9 1956 999999999 sharan
192.718002 999999999.999999 1995/12/25 19:42:35.0 1979/12/25 19:42:35.0
75 10 1999 101010101 vijay
102.718002 111111111.999999 1915/12/25 20:42:35.0 1980/12/25 20:42:35.0
76 11 2010 121212121 Prasad
112.718002 111111111.222222 2005/12/25 21:42:35.0 2005/12/25 21:42:35.0
77 12 2069 131313131 jiten
122.718002 222222222.333333 2025/12/25 22:42:35.0 2025/12/25 22:42:35.0
78 13 1857 141414141 hiten
132.718002 333333333.444444 2035/12/25 23:42:35.0 2035/12/25 23:42:35.0
79 14 1545 151515151 methane
126.718002 444444444.555555 2045/12/25 0:42:35.0 2032/12/25 0:42:35.0
80 15 1889 161616161 ethane
211.718002 555555555.222222 2065/12/25 1:42:35.0 2005/12/25 1:42:35.0
82 ---------------------------------------------------------
83 t1.f1 t1.f2 t1.f3 t1.f4 t1.f5 t1.f6 t1.f7 t1.f8 t1.f9
84 ---------------------------------------------------------
85 1 2011 111111111 Govind
113.140999 111111111.111111 1915/12/25 11:42:35.0 1971/12/25 11:42:35.0
86 4 1973 444444444 kiran
142.718002 444444444.444444 1946/12/25 14:42:35.0 1974/12/25 14:42:35.0
87 7 1965 777777777 Praba
172.718002 777777777.777777 1975/12/25 17:42:35.0 1977/12/25 17:42:35.0
88 10 1999 101010101 vijay
102.718002 111111111.999999 1915/12/25 20:42:35.0 1980/12/25 20:42:35.0
89 13 1857 141414141 hiten
132.718002 333333333.444444 2035/12/25 23:42:35.0 2035/12/25 23:42:35.0
90 16 1789 171717171 sanjay
222.718002 666666666.777777 2010/12/25 2:42:35.0 2010/12/25 2:42:35.0
91 19 2048 777755555 Sushant
277.717987 333333333.999999 2023/12/25 5:42:35.0 2011/12/25 4:42:35.0
93 ---------------------------------------------------------
94 t1.f1 t1.f2 t1.f3 t1.f4 t1.f5 t1.f6 t1.f7 t1.f8 t1.f9
95 ---------------------------------------------------------
96 1 2011 111111111 Govind
113.140999 111111111.111111 1915/12/25 11:42:35.0 1971/12/25 11:42:35.0
97 2 1995 222222222 Gopal
114.567001 222222222.222222 1926/5/16 12:32:14.0 1971/12/25 11:42:35.0
98 3 2008 333666999 kishor
122.699997 333333333.333333 1937/8/15 13:45:36.0 1973/8/15 13:45:36.0
99 4 1973 444444444 poonam
142.718002 444444444.444444 1946/12/25 14:42:35.0 1974/12/25 14:42:35.0
100 5 2005 555555555 ganesh
152.718002 555555555.555555 1955/12/25 15:42:35.0 1975/12/25 15:42:35.0
101 6 1962 666666666 suresh
162.718002 666666666.666666 1965/12/25 16:42:35.0 1976/12/25 16:42:35.0
102 7 1965 777777777 Praba
172.718002 777777777.777777 1978/9/12 17:42:35.0 1977/12/25 17:42:35.0
103 8 1942 888888888 karan
182.718002 888888888.888888 1985/12/25 12:34:56.0 1978/12/25 18:42:35.0
104 9 1956 999999999 sharan
192.718002 999999999.999999 1995/12/25 19:42:35.0 1979/12/25 19:42:35.0
105 10 1999 101010101 vijay
102.718002 111111111.999999 1915/12/25 20:42:35.0 1980/12/25 20:42:35.0
106 11 2010 121212121 Prasad
112.718002 111111111.222222 2005/12/25 21:42:35.0 2005/12/25 21:42:35.0
107 12 2069 131313131 jiten
122.718002 222222222.333333 2025/12/25 22:42:35.0 2025/12/25 22:42:35.0
108 16 1789 171717171 sanjay
222.718002 666666666.777777 2010/12/25 2:42:35.0 2010/12/25 2:42:35.0
109 17 2032 181818181 vikrant
233.718002 777777777.888888 2020/12/25 3:42:35.0 2020/12/25 3:42:35.0
111 +---------------------------------------+
118 +---------------------------------------+
119 \e[?
1034hSQL
> select * from t1
;
120 +------+-----------+---------------------+-----------+---------------+-------------------------+-----------+---------+--------------------+
121 | f1 | f2 | f3 | f4 | f5 | f6 | f7 | f8 | f9 |
122 +------+-----------+---------------------+-----------+---------------+-------------------------+-----------+---------+--------------------+
123 |
1 |
2011 |
111111111 | Govind |
113.141 |
111111111.111111 |
1915-12-25|
11:42:35|
1971-12-25 11:42:35|
124 |
2 |
1995 |
222222222 | Gopal |
114.567 |
222222222.222222 |
1926-05-16|
12:32:14|
1971-12-25 11:42:35|
125 |
3 |
2008 |
333666999 | kishor |
122.7 |
333333333.333333 |
1937-08-15|
13:45:36|
1973-08-15 13:45:36|
126 |
4 |
1973 |
444444444 | poonam |
142.718 |
444444444.444444 |
1946-12-25|
14:42:35|
1974-12-25 14:42:35|
127 |
5 |
2005 |
555555555 | ganesh |
152.718 |
555555555.555555 |
1955-12-25|
15:42:35|
1975-12-25 15:42:35|
128 |
6 |
1962 |
666666666 | suresh |
162.718 |
666666666.666666 |
1965-12-25|
16:42:35|
1976-12-25 16:42:35|
129 |
7 |
1965 |
777777777 | Praba |
172.718 |
777777777.777777 |
1978-09-12|
17:42:35|
1977-12-25 17:42:35|
130 |
8 |
1942 |
888888888 | karan |
182.718 |
888888888.888888 |
1985-12-25|
12:34:56|
1978-12-25 18:42:35|
131 |
9 |
1956 |
999999999 | sharan |
192.718 |
999999999.999999 |
1995-12-25|
19:42:35|
1979-12-25 19:42:35|
132 |
10 |
1999 |
101010101 | vijay |
102.718 |
111111111.999999 |
1915-12-25|
20:42:35|
1980-12-25 20:42:35|
133 |
11 |
2010 |
121212121 | Prasad |
112.718 |
111111111.222222 |
2005-12-25|
21:42:35|
2005-12-25 21:42:35|
134 |
12 |
2069 |
131313131 | jiten |
122.718 |
222222222.333333 |
2025-12-25|
22:42:35|
2025-12-25 22:42:35|
135 |
16 |
1789 |
171717171 | sanjay |
222.718 |
666666666.777777 |
2010-12-25|
02:42:35|
2010-12-25 02:42:35|
136 |
17 |
2032 |
181818181 | vikrant |
233.718 |
777777777.888888 |
2020-12-25|
03:42:35|
2020-12-25 03:42:35|
137 +------+-----------+---------------------+-----------+---------------+-------------------------+-----------+---------+--------------------+
138 SQLRowCount returns
14