SHARE
TWEET

Query results

a guest Apr 19th, 2019 100 Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. >final.query([Dept=4],[DocID,Age])
  2. DocID:40 Age:NA
  3. DocID:4 Age:35
  4. DocID:1 Age:98
  5. DocID:2 Age:36
  6. DocID:0 Age:35
  7. DocID:9 Age:36
  8. DocID:43 Age:NA
  9.  
  10. >final.query([Dept=4],[Age])
  11. Age:NA
  12. Age:35
  13. Age:98
  14. Age:36
  15. Age:35
  16. Age:36
  17. Age:NA
  18.  
  19. >final.query([Dept=4,Age>35],[DocID,Age])
  20. DocID:1 Age:98
  21. DocID:2 Age:36
  22. DocID:9 Age:36
  23.  
  24. >final.query([],[])
  25. Spec1:61 Gender:2 Salary:68800 Xtra:10
  26. Salary:66200 Spec1:96 Dept:5 State:40 City:22
  27. Salary:66200 Dept:6 State:40 City:20
  28. Salary:84600 State:48 Spec1:46 Gender:2 Dept:4
  29. Dept:4 Salary:181800 Age:35
  30. Spec1:66 Salary:56300 Age:54 Gender:1
  31. Spec1:61 Gender:2 Salary:72800
  32. Dept:4 Age:98
  33. City:2 Salary:96700 Dept:3
  34. City:3 Salary:96700 Dept:3
  35. City:4 Salary:96700 Dept:3
  36. State:10 Spec1:71
  37. Dept:4 Salary:181800 Age:36
  38. Dept:4 Salary:185800 Age:35
  39. Gender:2 Salary:148500 Dept:1
  40. Age:77 Gender:1
  41. Dept:5 State:44 Xtra:22
  42. Gender:1 City:2
  43. Dept:4 Salary:181800 Age:36
  44. Age:76 Salary:170000
  45. Age:28 State:15 Spec1:76
  46. State:7 Age:97 Spec1:56 Gender:2 Salary:181800 Dept:2 City:27
  47. Salary:130300 Spec1:41 Age:91
  48. Age:56
  49. Gender:2 Xtra:11
  50. State:16 Spec1:26 Dept:3
  51. Gender:2 Salary:122000
  52. Salary:176600 Dept:1
  53. Age:34 Gender:2
  54. Dept:2
  55. Salary:47300 State:16 Gender:2
  56. Dept:4
  57. Salary:47300 State:16 Gender:2 Children:4
  58. Gender:2 Spec1:26 Age:78
  59. Salary:97000 Dept:3
  60. City:4 Salary:97000 Dept:3
  61.  
  62. >final.count([Dept],[0])
  63. 20
  64.  
  65. >final.count([Dept],[1])
  66. 6
  67.  
  68. >final.insert(DocID:50 Spec1:61 Gender:1)
  69. Duplicate DocID error!
  70.  
  71. >final.insert(DocID:111 Spec1:66 Salary:40000 Age:80)
  72. DocID:111 Spec1:66 Salary:40000 Age:80
  73.  
  74. >final.insert(Spec1:66 Salary:50000 Age:80)
  75. DocID:781 Spec1:66 Salary:50000 Age:80
  76.  
  77. >final.query([Age>70],[DocID,Salary])
  78. DocID:1 Salary:NA
  79. DocID:7 Salary:NA
  80. DocID:555 Salary:170000
  81. DocID:666 Salary:181800
  82. DocID:66 Salary:130300
  83. DocID:620 Salary:NA
  84. DocID:111 Salary:40000
  85. DocID:781 Salary:50000
RAW Paste Data
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
 
Top