select.out 5.83 KB
Newer Older
1 2 3 4
QUERY: SELECT onek.* WHERE onek.unique1 < 10;
unique1|unique2|two|four|ten|twenty|hundred|thousand|twothousand|fivethous|tenthous|odd|even|stringu1|stringu2|string4
-------+-------+---+----+---+------+-------+--------+-----------+---------+--------+---+----+--------+--------+-------
      0|    998|  0|   0|  0|     0|      0|       0|          0|        0|       0|  0|   1|AAAAAA  |KMBAAA  |OOOOxx 
5 6 7
      1|    214|  1|   1|  1|     1|      1|       1|          1|        1|       1|  2|   3|BAAAAA  |GIAAAA  |OOOOxx 
      2|    326|  0|   2|  2|     2|      2|       2|          2|        2|       2|  4|   5|CAAAAA  |OMAAAA  |OOOOxx 
      3|    431|  1|   3|  3|     3|      3|       3|          3|        3|       3|  6|   7|DAAAAA  |PQAAAA  |VVVVxx 
8
      4|    833|  0|   0|  4|     4|      4|       4|          4|        4|       4|  8|   9|EAAAAA  |BGBAAA  |HHHHxx 
9 10
      5|    541|  1|   1|  5|     5|      5|       5|          5|        5|       5| 10|  11|FAAAAA  |VUAAAA  |HHHHxx 
      6|    978|  0|   2|  6|     6|      6|       6|          6|        6|       6| 12|  13|GAAAAA  |QLBAAA  |OOOOxx 
11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139 140 141 142 143 144 145 146 147 148 149 150 151 152 153 154 155 156 157 158 159 160 161 162 163 164 165 166 167 168 169 170 171 172 173 174 175 176 177 178 179 180 181 182 183 184 185 186 187 188 189 190 191 192 193 194 195 196 197 198 199 200 201 202 203 204 205 206 207 208 209 210 211 212 213 214 215 216 217 218 219 220 221 222 223 224 225 226 227 228 229 230 231 232 233 234 235 236 237 238 239 240
      7|    647|  1|   3|  7|     7|      7|       7|          7|        7|       7| 14|  15|HAAAAA  |XYAAAA  |VVVVxx 
      8|    653|  0|   0|  8|     8|      8|       8|          8|        8|       8| 16|  17|IAAAAA  |DZAAAA  |HHHHxx 
      9|     49|  1|   1|  9|     9|      9|       9|          9|        9|       9| 18|  19|JAAAAA  |XBAAAA  |HHHHxx 
(10 rows)

QUERY: SELECT onek.unique1, onek.stringu1
   WHERE onek.unique1 < 20
   ORDER BY unique1 using >;
unique1|stringu1
-------+--------
     19|TAAAAA  
     18|SAAAAA  
     17|RAAAAA  
     16|QAAAAA  
     15|PAAAAA  
     14|OAAAAA  
     13|NAAAAA  
     12|MAAAAA  
     11|LAAAAA  
     10|KAAAAA  
      9|JAAAAA  
      8|IAAAAA  
      7|HAAAAA  
      6|GAAAAA  
      5|FAAAAA  
      4|EAAAAA  
      3|DAAAAA  
      2|CAAAAA  
      1|BAAAAA  
      0|AAAAAA  
(20 rows)

QUERY: SELECT onek.unique1, onek.stringu1
   WHERE onek.unique1 > 980
   ORDER BY stringu1 using <;
unique1|stringu1
-------+--------
    988|AMAAAA  
    989|BMAAAA  
    990|CMAAAA  
    991|DMAAAA  
    992|EMAAAA  
    993|FMAAAA  
    994|GMAAAA  
    995|HMAAAA  
    996|IMAAAA  
    997|JMAAAA  
    998|KMAAAA  
    999|LMAAAA  
    981|TLAAAA  
    982|ULAAAA  
    983|VLAAAA  
    984|WLAAAA  
    985|XLAAAA  
    986|YLAAAA  
    987|ZLAAAA  
(19 rows)

QUERY: SELECT onek.unique1, onek.string4
   WHERE onek.unique1 > 980
   ORDER BY string4 using <, unique1 using >;
unique1|string4
-------+-------
    999|AAAAxx 
    995|AAAAxx 
    983|AAAAxx 
    982|AAAAxx 
    981|AAAAxx 
    998|HHHHxx 
    997|HHHHxx 
    993|HHHHxx 
    990|HHHHxx 
    986|HHHHxx 
    996|OOOOxx 
    991|OOOOxx 
    988|OOOOxx 
    987|OOOOxx 
    985|OOOOxx 
    994|VVVVxx 
    992|VVVVxx 
    989|VVVVxx 
    984|VVVVxx 
(19 rows)

QUERY: SELECT onek.unique1, onek.string4
   WHERE onek.unique1 > 980
   ORDER BY string4 using >, unique1 using <;
unique1|string4
-------+-------
    984|VVVVxx 
    989|VVVVxx 
    992|VVVVxx 
    994|VVVVxx 
    985|OOOOxx 
    987|OOOOxx 
    988|OOOOxx 
    991|OOOOxx 
    996|OOOOxx 
    986|HHHHxx 
    990|HHHHxx 
    993|HHHHxx 
    997|HHHHxx 
    998|HHHHxx 
    981|AAAAxx 
    982|AAAAxx 
    983|AAAAxx 
    995|AAAAxx 
    999|AAAAxx 
(19 rows)

QUERY: SELECT onek.unique1, onek.string4
   WHERE onek.unique1 < 20
   ORDER BY unique1 using >, string4 using <;
unique1|string4
-------+-------
     19|OOOOxx 
     18|VVVVxx 
     17|HHHHxx 
     16|OOOOxx 
     15|VVVVxx 
     14|AAAAxx 
     13|OOOOxx 
     12|AAAAxx 
     11|OOOOxx 
     10|AAAAxx 
      9|HHHHxx 
      8|HHHHxx 
      7|VVVVxx 
      6|OOOOxx 
      5|HHHHxx 
      4|HHHHxx 
      3|VVVVxx 
      2|OOOOxx 
      1|OOOOxx 
      0|OOOOxx 
(20 rows)

QUERY: SELECT onek.unique1, onek.string4
   WHERE onek.unique1 < 20
   ORDER BY unique1 using <, string4 using >;
unique1|string4
-------+-------
      0|OOOOxx 
      1|OOOOxx 
      2|OOOOxx 
      3|VVVVxx 
      4|HHHHxx 
      5|HHHHxx 
      6|OOOOxx 
      7|VVVVxx 
      8|HHHHxx 
      9|HHHHxx 
     10|AAAAxx 
     11|OOOOxx 
     12|AAAAxx 
     13|OOOOxx 
     14|AAAAxx 
     15|VVVVxx 
     16|OOOOxx 
     17|HHHHxx 
     18|VVVVxx 
     19|OOOOxx 
(20 rows)

QUERY: SELECT two, stringu1, ten, string4
   INTO TABLE temp
   FROM onek;
QUERY: SELECT p.name, p.age FROM person* p;
name   |age
-------+---
mike   | 40
joe    | 20
sally  | 34
sandra | 19
alex   | 30
sue    | 50
denise | 24
sarah  | 88
teresa | 38
nan    | 28
leah   | 68
wendy  | 78
melissa| 28
joan   | 18
mary   |  8
jane   | 58
liza   | 38
jean   | 28
jenifer| 38
juanita| 58
susan  | 78
zena   | 98
martie | 88
chris  | 78
pat    | 18
zola   | 58
louise | 98
edna   | 18
bertha | 88
sumi   | 38
koko   | 88
gina   | 18
rean   | 48
sharon | 78
paula  | 68
julie  | 68
belinda| 38
karen  | 48
carina | 58
diane  | 18
esther | 98
trudy  | 88
fanny  |  8
carmen | 78
lita   | 25
pamela | 48
sandy  | 38
trisha | 88
vera   | 78
velma  | 68
sharon | 25
sam    | 30
bill   | 20
fred   | 28
larry  | 60
jeff   | 23
cim    | 30
linda  | 19
(58 rows)

241
QUERY: SELECT p.name, p.age FROM person* p ORDER BY age using >, name;
242 243 244 245
name   |age
-------+---
esther | 98
louise | 98
246 247
zena   | 98
bertha | 88
248
koko   | 88
249
martie | 88
250
sarah  | 88
251
trisha | 88
252 253 254
trudy  | 88
carmen | 78
chris  | 78
255
sharon | 78
256
susan  | 78
257
vera   | 78
258
wendy  | 78
259
julie  | 68
260 261
leah   | 68
paula  | 68
262
velma  | 68
263
larry  | 60
264
carina | 58
265
jane   | 58
266
juanita| 58
267 268
zola   | 58
sue    | 50
269
karen  | 48
270
pamela | 48
271
rean   | 48
272
mike   | 40
273 274
belinda| 38
jenifer| 38
275
liza   | 38
276
sandy  | 38
277 278
sumi   | 38
teresa | 38
279
sally  | 34
280
alex   | 30
281
cim    | 30
282
sam    | 30
283
fred   | 28
284 285
jean   | 28
melissa| 28
286
nan    | 28
287
lita   | 25
288
sharon | 25
289 290 291
denise | 24
jeff   | 23
bill   | 20
292
joe    | 20
293
linda  | 19
294
sandra | 19
295 296
diane  | 18
edna   | 18
297 298 299
gina   | 18
joan   | 18
pat    | 18
300
fanny  |  8
301
mary   |  8
302 303
(58 rows)