php - mysql query to get the min values according to the latesttime stamp -

-

hi have try find solution query minvalues along latest time stamp.

i have following tables

table1

sno user_id   name subject  rank         timestamp  1    10      ss   maths1  1     2014-12-05 17:24:33   2    10      ss   maths2  2     2014-12-05 17:24:33  3    10      ph   phy1    3     2014-12-05 17:24:33  4    10      ph   phy2    4     2014-12-05 17:24:33  5    10      ss   maths1  2     2014-12-04 17:24:33   6    10      ss   maths2  1     2014-12-04 17:24:33  7    10      ph   phy1    3     2014-12-04 17:24:33  8    10      ph   phy2    4     2014-12-04 17:24:33

tabe12 

sno  name  status 1     ss    active 2     ph    active 3        inactive

so trying following result

 sno userid   name   subject  rank         timpestamp      1    10      ss   maths1  1     2014-12-05 17:24:33       2    10      ph   phy1    3     2014-12-05 17:24:33

so far tried query able latest time , least rank values subjects distinct name. not connected each other means getting latesttime stamp , least value other row. please me how solve it.

select distinct(t1.`name`),         t1.`user_id`,        t1.`subject`,         max(t1.`timestamp`) latest_timestamp,         min(t1.`rank `) rank    table1  t1,table2 t2   t1.`user_id`='10'  ,  t2.`status` = 'active'  , t1.`name` = t2.`name`   group t1.`exercise_id` order t1.`quality_id`, t1.`timestamp` asc

relational databases work on sets. think of data in different sets

  • you need set combines t1 , t2
  • you need subset of t1 consists of min rank , max timestamp each user_id , name.

so t1 , t2 joined generating universe of data , columns need. join subquery contianing subset filter out non max timestamp , non-min rank want. 

select t1values.name,         t1values.user_id,        t1values.subject,         t1values.rank,        t1values.timestamp table2 t2 inner join table1 t1values   on t1values.sno = t2.sno  , t2.status='active' inner join (select user_id, name max(timestamp) maxtime, min(rank) mrank              table1              group user_id, name) t1  on t1.name = t1values.name , t1.user_id = t1values.user_id , t1.maxtime = t1values.timestamp , t1.rank = t1values.mrank t1values.user_id='10'  order t1values.quality_id, t1values.timestamp asc

Comments

Post a Comment

Popular posts from this blog

python - mat is not a numerical tuple : openCV error -

-
i have write down code showing error ma not getting it: please help: showing mat not numerical tuple: import cv import cv2 capture = cv2.videocapture("j.3gp") while(1): _, frame1 = capture.read() grayimage1 = cv2.cvtcolor(frame1, cv2.color_bgr2gray) _, frame2 = capture.read() grayimage2 = cv2.cvtcolor(frame2, cv2.color_bgr2gray) differenceimage = cv2.absdiff(grayimage1,grayimage2) thresholdimage = cv2.threshold(differenceimage,25,255,cv2.thresh_binary) cv2.imshow("difference image", differenceimage) cv2.imshow("threshold image", thresholdimage) cv2.imshow("image", frame1) k = cv2.waitkey(30) & 0xff error arising : ----------------------------------------------------------------------------------------- traceback (most recent call last): file "desk.py", line 15, in <module> cv2.imshow("threshold image", thresholdimage) typeerror: mat not numerical tuple ...
Read more

c# - MSAA finds controls UI Automation doesn't -

-
i'm working on automating windows application. i'm using teststack white framework. i've hit problem. program has 'window' object cannot see inside of. white shows no controls inside of it. inspect.exe shows no controls inside of either when running in ui automation mode. if switch inspect msaa see controls inside fine. there anyway me use msaa c# handle on these controls? if can identify msaa functions need, can use p/invoke call them c#. here's example article doing msaa: http://www.codeproject.com/articles/38906/ui-automation-using-microsoft-active-accessibility also, pinvoke.net can used identify iaccessible (msaa) functions: http://www.pinvoke.net/search.aspx?search=iaccessible&namespace=[all] here's answer along lines: msaa com-based? finally, alternative p/invoke, might able use tlbimp.exe create wrapper assembly oleacc.dll, , access msaa functions through it. i'm not sure if works msaa, it's worth try. as e...
Read more

wordpress - .htaccess: RewriteRule: bad flag delimiters -

-
pulling hair out on one. have following .htaccess file custom redirects in addition wordpress's default settings. when tested on local wamp server worked fine after moving production i'm not getting rewriterule: bad flag delimiters error in server log , after while site goes down internal server error any appreciated. in advance! <ifmodule mod_rewrite.c> rewriteengine on rewritebase / rewriterule ^rockford_weddings___welcome\.html$ /wedding/ [r=301,l] rewriterule ^blog/?$ /journal/ [r=301,l] rewriterule ^blog/(.*)$ /$1 [r=301,l] rewriterule ^portraitinvestment/?$ /portraitinvestment\.pdf [r=301,l] rewriterule ^weddinginvestment/?$ /weddinginvestment\.pdf [r=301,l] rewriterule ^holidaycards2014/?$ /holidaycards2014\.pdf [r=301,l] </ifmodule> # begin wordpress <ifmodule mod_rewrite.c> rewriteengine on rewritebase / rewriterule ^index\.php$ - [l] rewritecond %{request_filename} !-f rewritecond %{request_filename} !-d rewriterule . /index.php [l] </...
Read more