Guest User

example for postgres

a guest
Aug 9th, 2014
199
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.65 KB | None | 0 0
  1. =============
  2. SAMPLE DATA
  3. =============
  4. 2008,a+,81.03,17.47,13324,3184
  5. 2008,y+,74.96,11.12,16508,0
  6. 2008,e+,73.28,14.25,14080,2428
  7. 2008,bt-,70.79,19.26,14897,1611
  8. 2008,E%+,70.38,19.27,15047,1461
  9. 2008,et+,68.06,18.62,14707,1801
  10. 2008,N%+,67.52,20.46,15607,901
  11. 2008,n - test+,67.39,23.82,16508,0
  12. 2008,Score+,67.21,26.14,16508,0
  13. 2008,fc+,66.64,20.08,14656,1852
  14. 2008,r+,58.99,22.87,15797,711
  15. 2008,S%Chg+,58.61,21.36,15416,1092
  16. 2008,ES%Chg+,56.72,23.13,15592,916
  17. 2007,a+,81.03,15.95,12256,3703
  18. 2007,y+,74.1,11.18,15959,0
  19. 2007,e+,73.56,14.69,13161,2798
  20. 2007,E%+,70.58,19.47,14333,1626
  21. 2007,bt-,68.78,18.93,14642,1317
  22. 2007,N%+,67.91,20.97,14962,997
  23. 2007,et+,66.89,18.91,14095,1864
  24. 2007,Score+,66.7,27.18,15959,0
  25. 2007,n - test+,66.5,24.1,15959,0
  26. 2007,fc+,64.29,19.96,14124,1835
  27. 2007,r+,60.82,22.08,15291,668
  28. 2007,S%Chg+,58.2,21.42,14826,1133
  29. 2007,ES%Chg+,57.32,23.61,14776,1183
  30.  
  31. ===================
  32. SORT RESULT FOR TEST 1
  33. =====================
  34. 1 2008 a+ 77.28
  35. 2 2008 y+ 74.96
  36. 3 2008 e+ 73.28
  37. 4 2008 bt- 70.79
  38. 5 2008 E%+ 70.38
  39. 6 2008 et+ 68.06
  40. 7 2008 N%+ 67.52
  41. 8 2008 n - test+ 67.39
  42. 9 2008 Score+ 67.21
  43. 10 2008 fc+ 66.64
  44. 11 2008 r+ 58.99
  45. 12 2008 S%Chg+ 58.61
  46. 13 2008 ES%Chg+ 56.72
  47.  
  48. 1 2007 a+ 81.03
  49. 2 2007 y+ 74.1
  50. 3 2007 e+ 73.56
  51. 4 2007 E%+ 70.58
  52. 5 2007 bt- 68.78
  53. 6 2007 N%+ 67.91
  54. 7 2007 et+ 66.89
  55. 8 2007 Score+ 66.7
  56. 9 2007 n - test+ 66.5
  57. 10 2007 fc+ 64.29
  58. 11 2007 r+ 60.82
  59. 12 2007 S%Chg+ 58.2
  60. 13 2007 ES%Chg+ 57.32
  61.  
  62. =============
  63. SORT LOCATIONS FOR TEST 1
  64. =============
  65. a+ 1 1
  66. y+ 2 2
  67. e+ 3 3
  68. bt- 4 5
  69. E%+ 5 4
  70. et+ 6 7
  71. N%+ 7 6
  72. n - test+ 8 9
  73. Score+ 9 8
  74. fc+ 10 10
  75. r+ 11 11
  76. S%Chg+ 12 12
  77. ES%Chg+ 13 13
Advertisement
Add Comment
Please, Sign In to add comment