API tools faq
paste
Zorbing

[DB] select_pres.log

Zorbing
May 18th, 2014
285
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 11.60 KB | None | 0 0
raw download clone embed print report
  1. connect to dbs
  2.  
  3. Datenbankverbindungsinformationen
  4.  
  5. Datenbank-Server = DB2/NT64 10.5.1
  6. SQL-Berechtigungs-ID = Zorbing
  7. Aliasname der lokalen Datenbank = DBS
  8.  
  9.  
  10. SELECT pres_name, birth_year FROM president WHERE state_born = 'Texas'
  11.  
  12. PRES_NAME BIRTH_YEAR
  13. -------------------- -----------
  14. Eisenhower D D 1890
  15. Kennedy J F 1917
  16.  
  17. 2 Satz/Sätze ausgewählt.
  18.  
  19.  
  20. SELECT p.pres_name, p.birth_year, p.years_serv, p.party, p.state_born FROM president p WHERE death_age IS NULL
  21.  
  22. PRES_NAME BIRTH_YEAR YEARS_SERV PARTY STATE_BORN
  23. -------------------- ----------- ----------- -------------------- --------------------
  24. Bush G 1924 4 Republican Massachusetts
  25. Carter J E 1924 4 Democratic Georgia
  26. Clinton W J 1946 8 Democratic Arkansas
  27. Ford G R 1913 5 Republican Georgia
  28. Nixon R M 1913 5 Republican Nebraska
  29. Reagan R 1911 8 Republican Illinois
  30.  
  31. 6 Satz/Sätze ausgewählt.
  32.  
  33.  
  34. SELECT DISTINCT party FROM president
  35.  
  36. PARTY
  37. --------------------
  38. Demo-Rep
  39. Democratic
  40. Federalist
  41. Republican
  42. Whig
  43.  
  44. 5 Satz/Sätze ausgewählt.
  45.  
  46.  
  47. SELECT * FROM president p LEFT JOIN state s ON p.state_born = s.state_name LEFT OUTER JOIN pres_hobby h ON p.pres_name = h.pres_name LEFT OUTER JOIN pres_marriage m ON p.pres_name = m.pres_name LEFT OUTER JOIN election e ON p.pres_name = e.candidate WHERE p.pres_name LIKE '%Bush%'
  48.  
  49. PRES_NAME BIRTH_YEAR YEARS_SERV DEATH_AGE PARTY STATE_BORN STATE_NAME YEAR_ENTERED PRES_NAME HOBBY PRES_NAME SPOUSE_NAME PR_AGE SP_AGE NR_CHILDREN MAR_YEAR ELECTION_YEAR CANDIDATE VOTES WINNER_LOSER_INDIC
  50. -------------------- ----------- ----------- ----------- -------------------- -------------------- -------------------- ------------ -------------------- -------------------- -------------------- -------------------- ----------- ----------- ----------- ----------- ------------- -------------------- ----------- --------------------
  51. Bush G 1924 4 - Republican Massachusetts Massachusetts 1776 Bush G Sailing Bush G Pierce B 20 19 5 1945 1988 Bush G 426 W
  52. Bush G 1924 4 - Republican Massachusetts Massachusetts 1776 Bush G Sailing Bush G Pierce B 20 19 5 1945 1992 Bush G 168 L
  53.  
  54. 2 Satz/Sätze ausgewählt.
  55.  
  56.  
  57. SELECT * FROM president WHERE party = 'Republican' OR state_born = 'Texas'
  58.  
  59. PRES_NAME BIRTH_YEAR YEARS_SERV DEATH_AGE PARTY STATE_BORN
  60. -------------------- ----------- ----------- ----------- -------------------- --------------------
  61. Arthur C A 1830 3 56 Republican Vermont
  62. Bush G 1924 4 - Republican Massachusetts
  63. Coolidge C 1872 5 60 Republican Vermont
  64. Eisenhower D D 1890 8 79 Republican Texas
  65. Ford G R 1913 5 - Republican Georgia
  66. Garfield J A 1831 0 49 Republican Ohio
  67. Grant U S 1822 8 63 Republican Ohio
  68. Harding W G 1865 2 57 Republican Ohio
  69. Harrison B 1833 4 67 Republican Ohio
  70. Hayes R B 1822 4 70 Republican Ohio
  71. Hoover H C 1871 4 90 Republican Iowa
  72. Kennedy J F 1917 2 46 Democratic Texas
  73. Lincoln A 1809 4 56 Republican Kentucky
  74. McKinley W 1843 4 58 Republican Ohio
  75. Nixon R M 1913 5 - Republican Nebraska
  76. Reagan R 1911 8 - Republican Illinois
  77. Roosevelt T 1858 7 60 Republican New York
  78. Taft W H 1857 4 72 Republican Ohio
  79.  
  80. 18 Satz/Sätze ausgewählt.
  81.  
  82.  
  83. SELECT * FROM president WHERE years_serv IN (4, 8, 12)
  84.  
  85. PRES_NAME BIRTH_YEAR YEARS_SERV DEATH_AGE PARTY STATE_BORN
  86. -------------------- ----------- ----------- ----------- -------------------- --------------------
  87. Adams J 1735 4 90 Federalist Massachusetts
  88. Adams J Q 1767 4 80 Demo-Rep Massachusetts
  89. Buchanan J 1791 4 77 Democratic Pennsylvania
  90. Bush G 1924 4 - Republican Massachusetts
  91. Carter J E 1924 4 - Democratic Georgia
  92. Cleveland G 1837 8 71 Democratic New Jersey
  93. Clinton W J 1946 8 - Democratic Arkansas
  94. Eisenhower D D 1890 8 79 Republican Texas
  95. Grant U S 1822 8 63 Republican Ohio
  96. Harrison B 1833 4 67 Republican Ohio
  97. Hayes R B 1822 4 70 Republican Ohio
  98. Hoover H C 1871 4 90 Republican Iowa
  99. Jackson A 1767 8 78 Democratic South Carolina
  100. Jefferson T 1743 8 83 Demo-Rep Virginia
  101. Johnson A 1808 4 66 Democratic North Carolina
  102. Lincoln A 1809 4 56 Republican Kentucky
  103. Madison J 1751 8 85 Demo-Rep Virginia
  104. McKinley W 1843 4 58 Republican Ohio
  105. Monroe J 1758 8 73 Demo-Rep Virginia
  106. Pierce F 1801 4 64 Democratic New Hampshire
  107. Polk J K 1795 4 53 Democratic North Carolina
  108. Reagan R 1911 8 - Republican Illinois
  109. Roosevelt F D 1882 12 63 Democratic New York
  110. Taft W H 1857 4 72 Republican Ohio
  111. Van Buren M 1782 4 79 Democratic New York
  112. Wilson W 1856 8 67 Democratic Virginia
  113.  
  114. 26 Satz/Sätze ausgewählt.
  115.  
  116.  
  117. SELECT * FROM state ORDER BY year_entered
  118.  
  119. STATE_NAME YEAR_ENTERED
  120. -------------------- ------------
  121. Massachusetts 1776
  122. Pennsylvania 1776
  123. Virginia 1776
  124. Connecticut 1776
  125. South Carolina 1776
  126. Maryland 1776
  127. New Jersey 1776
  128. Georgia 1776
  129. New Hampshire 1776
  130. Delawhare 1776
  131. New York 1776
  132. North Carolina 1776
  133. Rhode Island 1776
  134. Vermont 1791
  135. Kentucky 1792
  136. Tennesee 1796
  137. Ohio 1803
  138. Louisiana 1812
  139. Indiana 1816
  140. Mississippi 1817
  141. Illinois 1818
  142. Alabama 1819
  143. Maine 1820
  144. Missouri 1821
  145. Arkansas 1836
  146. Michigan 1837
  147. Florida 1845
  148. Texas 1845
  149. Iowa 1846
  150. Wisconsin 1848
  151. California 1850
  152. Minnesota 1858
  153. Oregon 1859
  154. Kansas 1861
  155. West Virginia 1863
  156. Nevada 1864
  157. Nebraska 1867
  158. Colorado 1876
  159. North Dakota 1889
  160. South Dakota 1889
  161. Montana 1889
  162. Washington 1889
  163. Idaho 1890
  164. Wyoming 1890
  165. Utah 1896
  166. Oklahoma 1907
  167. New Mexico 1912
  168. Arizona 1912
  169. Alaska 1959
  170. Hawaii 1959
  171.  
  172. 50 Satz/Sätze ausgewählt.
  173.  
  174.  
  175. SELECT COUNT(*) AS count FROM election WHERE winner_loser_indic = 'L' UNION SELECT COUNT(*) FROM election WHERE winner_loser_indic = 'W'
  176.  
  177. COUNT
  178. -----------
  179. 12
  180. 42
  181.  
  182. 2 Satz/Sätze ausgewählt.
  183.  
  184.  
  185. SELECT * FROM president p INNER JOIN election e ON p.pres_name = e.candidate WHERE e.votes = ( SELECT MAX(votes) FROM election )
  186.  
  187. PRES_NAME BIRTH_YEAR YEARS_SERV DEATH_AGE PARTY STATE_BORN ELECTION_YEAR CANDIDATE VOTES WINNER_LOSER_INDIC
  188. -------------------- ----------- ----------- ----------- -------------------- -------------------- ------------- -------------------- ----------- --------------------
  189. Reagan R 1911 8 - Republican Illinois 1984 Reagan R 525 W
  190.  
  191. 1 Satz/Sätze ausgewählt.
  192.  
  193.  
  194. SELECT * FROM president WHERE pres_name IN ( SELECT candidate FROM election WHERE winner_loser_indic = 'W' GROUP BY candidate HAVING COUNT(candidate) <> 2 )
  195.  
  196. PRES_NAME BIRTH_YEAR YEARS_SERV DEATH_AGE PARTY STATE_BORN
  197. -------------------- ----------- ----------- ----------- -------------------- --------------------
  198. Adams J 1735 4 90 Federalist Massachusetts
  199. Bush G 1924 4 - Republican Massachusetts
  200. Carter J E 1924 4 - Democratic Georgia
  201. Johnson L B 1908 5 65 Democratic California
  202.  
  203. 4 Satz/Sätze ausgewählt.
Advertisement
Add Comment
Please, Sign In to add comment
Public Pastes
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!