?? select.out
字號:
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)
?? 快捷鍵說明
復(fù)制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -