select - Return MAX After Selection -

-

i new sql queries , having issue getting max of column speedo below current query

select  tblvehicle.rego ,tbljob.speedo  ,tbljob.dateentered tbljob inner join tblvehicle   on tbljob.vehicle_id = tblvehicle.id    jobtype_id = 2    order rego

which outputs

rego    speedo  dateentered 000jkc  147729  2010-05-10 10:56:55.040 000jkc  150145  2010-06-02 13:57:15.470 000jkc  169553  2011-01-06 12:24:09.143 000jkc  155149  2010-07-21 14:58:20.777 000jkc  157882  2010-09-17 16:39:48.480 000jkc  165660  2010-11-29 08:20:39.453 000jkc  164339  2010-11-18 16:19:19.213 000jkc  155149  2010-08-11 06:16:28.180 000rqd  65  2011-11-21 09:27:31.693 000rqd  6978    2012-03-06 15:18:06.987 000rqd  6766    2012-02-24 13:28:47.603 000rqd  12130   2012-08-28 09:29:18.027 000rqd  12145   2012-08-27 14:57:17.330 000rqd  21550   2013-04-15 19:30:30.160 000rqd  23640   2013-05-22 16:16:33.880

now max(speedo) of each rego only.

the max() function returns largest value of selected column.

select  tblvehicle.rego , max( tbljob.speedo ) ,tbljob.dateentered tbljob inner join tblvehicle   on tbljob.vehicle_id = tblvehicle.id    jobtype_id = 2    order rego

Comments

Post a Comment

Popular posts from this blog

c++ - OpenMP unpredictable overhead -

-
i have simple openmp code runs 4 empty threads , reports time: #include "omp.h" #include <sys/time.h> #include <cstdio> double start_time; void process_thread() { } int main(){ struct timeval tv; gettimeofday(&tv, null); start_time = 1000*((double)tv.tv_sec + 1e-6*(double)tv.tv_usec); printf("beginning time: %.3fms ",start_time-start_time); #pragma omp parallel schedule(static,1) for(int i=0;i<4;i++) process_thread(); gettimeofday(&tv, null); double cur_time = 1000*((double)tv.tv_sec + 1e-6*(double)tv.tv_usec); printf("finishing time: %.3fms\n\n",cur_time-start_time); } without openmp running time small , consistent: beginning time: 0.000ms finishing time: 0.050ms beginning time: 0.000ms finishing time: 0.050ms beginning time: 0.000ms finishing time: 0.049ms beginning time: 0.000ms finishing time: 0.049ms beginning time: 0.000ms finishing time: 0.050ms beginnin...
Read more

ruby on rails - RuntimeError: Circular dependency detected while autoloading constant - ActiveAdmin.register Role -

-
i using activeadmin , have file doing this: activeadmin.register role something--- end however, server gives me error: runtimeerror: circular dependency detected while autoloading constant role /library/ruby/gems/2.0.0/gems/activesupport-4.0.10/lib/active_support/dependencies.rb:461:in `load_missing_constant' /library/ruby/gems/2.0.0/gems/activesupport-4.0.10/lib/active_support/dependencies.rb:184:in `const_missing' ~/desktop/boxfox/app/admin/role.rb:1:in `<top (required)>' /library/ruby/gems/2.0.0/gems/activesupport-4.0.10/lib/active_support/dependencies.rb:424:in `load' /library/ruby/gems/2.0.0/gems/activesupport-4.0.10/lib/active_support/dependencies.rb:424:in `block in load_file' /library/ruby/gems/2.0.0/gems/activesupport-4.0.10/lib/active_support/dependencies.rb:616:in `new_constants_in' /library/ruby/gems/2.0.0/gems/activesupport-4.0.10/lib/active_support/dependencies.rb:423:in `load_file' /library/ruby/gems/2.0.0/gems/activesuppor...
Read more

javascript - Wordpress slider, not displayed 100% width -

-
so im making first wordpress theme scratch going fine got problem. want slider on homepage 1 thing wrong. im setting width of image 100% !important doesnt go 100% width. makes image wider not 100%. example here: http://bit.ly/11ouebg see image doesnt contain whole width. can see background-color. really weird, im using meteor slides. i hope can me out :d
Read more