sql - Help with MySQL query that is based on the number of clicks on an item -

sql - Help with MySQL query that is based on the number of clicks on an item -

January 15, 2011

मेरे पास एक टेबल सेटअप है (उदाहरण के लिए सरलीकृत):

  user_id item_id click_dt

प्रत्येक item_id में कई user_id है असल में यह आइटम पर क्लिक्स को संचित कर रहा है, जो कि user_id से जुड़ा हुआ है।

मैं इस के माध्यम से क्वेरी करना चाहता हूं और केवल click_dt पर आधारित प्रत्येक आइटम_आईडी के लिए नवीनतम यूज़र_आईडी की सूची चाहता हूं।

Item_id 55 के लिए 5 क्लिक हैं, आखिरी क्लिक या क्लिक डी डीटी डीईएससी दिखाने के लिए रिकॉर्ड होगा ....

क्या मतलब है? कोई मदद भयानक होगी ... धन्यवाद!

उपयोग करें:

  सेलेक्ट एक्स। * अपने योग से जुड़ें (SELECT t.item_id, MAX (t.click_dt) एएस max_date द्वारा t.item_id द्वारा yOUR_TABLE टी ग्रुप से y.item_id = x.item_id और y.max_date = x.clicked_dt < / कोड>   वैकल्पिक:  
  SELECT x.item_id, x.user_id, x.click_dt से (SELECT t.item_id, t.user_id, t.click_dt, केस WHEN @item = t.item_id फिर @Rownum: = @Rownum + 1 ELSE @rownum: आर.के. के रूप में = 1 ईडी, @ आईटीम: = टी.आईटीएएम_आईडी आपकी टाईबल से जुड़ें (SELECT @rownum: = 0, @item: = 0 ) आर आदेश द्वारा टी.टी.आई.आई.आई.आई.डी., क्लिक_ डीटी डीईएससी) x WHERE x.rk = 1


















Get link





Facebook





X





Pinterest





Email





Other Apps




Comments





Post a Comment







Popular Posts




IronPython in C#: No module named xmlrpclib -



    I am trying to create a web application with an interactive console for IronPython. When I try to import xmlrpclib into the General console of IronPython, it works. However, if I use IronPython inside my C # code, then it does not put an exception "a module named xmlrpclib", is it a known issue? Any solution to solve this issue?   Here is the code:    var testcode = @ "import xmlrpclib; apiarver = xmlrpclib.ServerProxy ('address', allow_none = true); print APIServer.Hello () ; "; Mystream str = newest Mystream (); ScriptEngine Engine = Python. Cretegenine (); Engine. Retyme.io asset output (str, system text encoding. ASCII); Engine. Serial.io.setuperoutput (str, systemtext.edcoding.aspx); ScriptScope scope = engine.CreateScope (); ScriptSource src = engine.CreateScriptSourceFromString (testCode); Src.Execute (scope); Sorry for the silly question, it has come to know that there is a path used by IronPathon inside me.       The C # code was not correct. I ...






qt creator - QtCreator importing makefile projects -



    Have you ever tried importing Classic C ++ / project into Qt Creator?   Say that I wanted to use some libraries in my GUI project, which must be created. how can I do this?      In Qt Creator 2.0.1 you can import projects using only * * Cmake, * .creator, * .pro or * .qmlproject   Then switch to cmake and you can import the project into Qt builder (Welcome tab -> Open project ...).   Alex     






php - cURL Cookie and 307 redirect issue -



    I currently have a script that loads my client using curls on another server Currently, the settings    curl_setopt ($ CH, CURLOPT_RETURNTRANSFER, 1); Curl_setopt ($ CH, CURLOPT_FOLLOWLOCATION, TRUE); Curl_setopt ($ ch, CURLOPT_AUTOREFERER, true); Curl_setopt ($ ch, CURLOPT_USERAGENT, $ UserAgent); Curl_setopt ($ CH, CURLOPT_HEADER, 0); $ Usecookie = ROOT_PATH "/public_html/football_parser/cookie.txt"; If ($ usecookie) {if (! Is_writable ($ usecookie)) {return "$ usecookie can not write cookie file, change the file's permission to 777 or read only for windows."; } Curl_setopt ($ ch, CURLOPT_COOKIEJAR, $ usecookie); Curl_setopt ($ ch, CURLOPT_COOKIEFILE, $ usecookie); } $ Output = curl_xac ($ ch);    I'm trying to load two example URLs   statto.com/football/teams/newcastle-united/2005-2006/results   and   statto.com/football/teams/newcastle-united/2008-2009/results   Without a second load without any problems  curl_setopt ($ ch, CURLOPT_FOLLOWLOCATION, TR...








Powered by Blogger