Order by weekno and year in Mysql -



Order by weekno and year in Mysql -

select abc.mnth mnth,sum(abc.info) info (select aaa.mnth mnth, aaa.info info ((select ontime.mnth mnth, ontime.info info (select ontimerecords.mnth mnth , round(((ontimerecords.count/completed.count)*100),2) info (select date_format(t.dtdelivery,'%v %x') mnth, count(*) count table1 t fcompleted = 1 , t.fstatus = 1 , t.dtdelivery >= '2013-01-01 00:00:00' , t.dtdelivery <= '2013-12-28 23:59:59' , find_in_set(t.sprojectcode,'all,pj1,pj2,hhfgh,tewrtert,dfgdgdf,project code,null,tyuire,dfgdfgdf,[select]') > 0 , t.dtdelivery <= t.dtdeliverydue grouping date_format(t.dtdelivery,'%v %x') order date_format(t.dtdelivery,'%v %x')) completed inner bring together (select date_format(t.dtdelivery,'%v %x') mnth, count(*) count table1 t fcompleted = 1 , t.fstatus = 1 , find_in_set(t.sprojectcode,'all,pj1,pj2,hhfgh,tewrtert,dfgdgdf,project code,null,tyuire,dfgdfgdf,[select]') > 0 , t.dtdelivery >= '2013-01-01 00:00:00' , t.dtdelivery <= '2013-12-28 23:59:59' , t.dtdelivery <= t.dtdeliverydue grouping date_format(t.dtdelivery,'%v %x') order date_format(t.dtdelivery,'%v %x')) ontimerecords on ontimerecords.mnth = completed.mnth) ontime) union (select monthdates.mnth mnth, monthdates.info info ((select distinct(date_format(adate,'%v %x')) mnth ,0 info ( select @maxdate - interval (a.a+(10*b.a)+(100*c.a)+(1000*d.a)) day adate (select 0 union select 1 union select 2 union select 3 union select 4 union select 5 union select 6 union select 7 union select 8 union select 9) a, /*10 day range*/ (select 0 union select 1 union select 2 union select 3 union select 4 union select 5 union select 6 union select 7 union select 8 union select 9) b, /*100 day range*/ (select 0 union select 1 union select 2 union select 3 union select 4 union select 5 union select 6 union select 7 union select 8 union select 9) c, /*1000 day range*/ (select 0 union select 1 union select 2 union select 3 union select 4 union select 5 union select 6 union select 7 union select 8 union select 9) d, /*10000 day range*/ (select @mindate :='2013-01-01 00:00:00', @maxdate :='2013-12-28 23:59:59') e ) f adate between @mindate , @maxdate order adate asc )) monthdates) ) aaa order aaa.mnth desc) abc grouping abc.mnth order str_to_date (abc.mnth,'%v %x');

i want generate study based on start date , end date. want weekwise report. have query result below..

week info 02 2013 0 06 2013 100 01 2013 0 05 2013 0 53 2012 0 04 2013 0 08 2013 100 03 2013 0 07 2013 100

i want result below

week info 53 2012 0 01 2013 0 02 2013 0 03 2013 0 04 2013 0 05 2013 0 06 2013 100 07 2013 100 08 2013 100

this query incredibly convoluted, , seems there order by on every psuedo-table select statement.

i seek removing order bys, check results, , (assuming results satisfactory) apply single order by @ end - order abc.mnth , seems date, , want in date order.

mysql

Comments

Post a Comment

Popular posts from this blog

web services - java.lang.NoClassDefFoundError: Could not initialize class net.sf.cglib.proxy.Enhancer -

web services - java.lang.NoClassDefFoundError: Could not initialize class net.sf.cglib.proxy.Enhancer - when trying request rest service @ time of response getting exception.. feb 21, 2013 2:34:49 pm com.sun.jersey.spi.container.containerresponse mapmappablecontainerexception severe: exception contained within mappablecontainerexception not mapped response, re-throwing http container java.lang.noclassdeffounderror: not initialize class net.sf.cglib.proxy.enhancer @ org.hibernate.proxy.pojo.cglib.cgliblazyinitializer.getproxyfactory(cgliblazyinitializer.java:117) @ org.hibernate.proxy.pojo.cglib.cglibproxyfactory.postinstantiate(cglibproxyfactory.java:43) @ org.hibernate.tuple.entity.pojoentitytuplizer.buildproxyfactory(pojoentitytuplizer.java:162) @ org.hibernate.tuple.entity.abstractentitytuplizer.<init>(abstractentitytuplizer.java:135) @ org.hibernate.tuple.entity.pojoentitytuplizer.<init>(pojoentitytuplizer.java:55) @ org.hibernate.tuple.e...
Read more

Accessing MATLAB's unicode strings from C -

Accessing MATLAB's unicode strings from C - how can access underlying unicode info of matlab strings through matlab engine or mex c interfaces? here's example. let's set unicode characters in utf-8 encoded file test.txt, read as fid=fopen('test.txt','r','l','utf-8'); s=fscanf(fid, '%s') in matlab. now if first feature('defaultcharacterset', 'utf-8') , c engevalstring(ep, "s") , output text file utf-8. proves matlab stores unicode internally. if mxarraytostring(enggetvariable(ep, "s")) , unicode2native(s, 'latin-1') give me in matlab: non-latin-1 characters replaced character code 26. need getting access underlying unicode info c string in unicode format (utf-8, utf-16, etc.), , preserving non-latin-1 characters. is possible? my platform os x, matlab r2012b. addendum: documentation explicitly states "[mxarraytostring()] supports multibyte encoded characters...
Read more

javascript - mongodb won't find my schema method in nested container -

javascript - mongodb won't find my schema method in nested container - i trying access method of schema stored within mixed container. here situation : have cases model can many different things, have schema each of these things stored in "casecontent" mixed property. var caseschema = mongoose.schema({ casecontent : {}, object : {type:string, default : "null"}, collision : {type : boolean, default : false} }); the casecontent property filled model of 1 of schemas, 1 exemple : var treeschema = new mongoose.schema({ applecount : {type : number, default : 3} }); treeschema.methods.dostuff = function (data) { console.log('hey, listen'); homecoming true; }; then, want utilize method of schema original container : caseschema.methods.dostuff = function (data) { if (this.casecontent.dostuff !== undefined) { this.casecontent.dostuff(); console.log('it worked'); } else { ...
Read more