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