StackOverflow's Popularity algorithm in MySQL -

-

आप MySQL में SO की लोकप्रियता एल्गोरिथ्म कैसे लिखेंगे?

धन्यवाद!

< पी> यह अपेक्षाकृत सरल है

<पूर्व> t = (प्रविष्टि पोस्ट का समय) - (8 दिसंबर, 2005)

आप दिनांक मानों को टाइमस्टैम्प में परिवर्तित कर सकते हैं (आप उपयोग कर सकते हैं), जो आपको एक पूर्णांक देता है जिसका इस्तेमाल बाकी हिस्सों में किया जा सकता है। 

  x = upvotes - downvotes

यह एक बहुत आसान होना चाहिए .. जाहिर है, MySQL घटाव का समर्थन करता है। 

  y = {1 यदि x & gt; 0, 0 यदि x = 0, -1 यदि x & lt; 0) z = {1 अगर x & lt; 0, अन्यथा x}

इन के लिए, MySQL के बयान पर एक नज़र डालें। 

  लॉग (z) + (y * t) / 45000   
 माईएसक्यूएल एक फ़ंक्शन है, इसलिए यह एक आसान होना चाहिए, बस सरल गणित।  
 और, आप एक बयान के साथ सब एक साथ टाई। आप अपने  चयन करें  कथन में मध्यवर्ती गणनाओं का उपयोग करके का उपयोग कर सकते हैं। उदाहरण के लिए:  
  का चयन करें @ x: = (upvotes - downvotes) x के रूप में, (xx & gt; 4) asXGreaterThanFour

Comments

Post a Comment

Popular posts from this blog

ios - Form Sheet content disappearing -

-
Image
I am trying to apply a form sheet. Looks like this on the storyboard: App background only when I run Appears and everything else is hidden. I am presenting a form sheet using model sheets - I am working with the form sheet and I (WREGLR Regular) size. Why is this happening?
Read more

Lists in scheme -

-
I am trying to write a function in the plan that takes every item list and class in the list, then returns the list As is (list xyz) . However, I'm not sure how to write a code that would do this. So far, I have (defined (category = list list) (cond [(empty? List) false) [and (list (SQL) (first A-list)) (Square-list) (The rest is a list)))]) but it returns to the list (cons y (cons z empty)) What can I do to return it to the list only in (list xyz) ? Thanks! You're almost there - make sure you type cons and List (The text book explains this section 13. You can find copies online). Conflict The first element for the 'rest' part and (usually) one (potentially empty) list as an example, (Opposition 1 blank) Number 1 as its first element and the empty list is in the form of 'rest' (Opposition 1 (Opposition 2 Empty)) No. 1 before Element, and (Opposition 2 empty) is in the form of 'rest'. List is just a simple shorth...
Read more

List View in C# -

-
I have a ListView in my C # and I want to select an item based on the number I give . Is it possible? Example: If my list adds, multiplied and divides as elements in the list, so if I give 2, then it has to be multiplied. All this should be programmatically If this is ListItem value 2 - I just had to go with it: _listView.SelectedValue = "2"; Or maybe more correct: _listView.SelectedValue = _input.ToString ();
Read more