mysql - Group by a field inside a nested query -


we have nested sql query want group field nested query rather grouping field on main query . 

select dataissue.value a,     count(value),     substring(issue.entry, 1, 3)  dataissue, issue  field = 'point_d_effort'    , dataissue.issue = issue.id      , issue in (          select issue          dataissue, issue           dataissue.issue = issue.id             , value = 'récit'             , substring(issue.entry,1,3) = 'ema'   )    , issue in (          select issue           dataissue, issue           dataissue.issue = issue.id             , value = 'fermée'             , substring(issue.entry,1,3) = 'ema'   )    , issue in (          select issue             dataissue, issue            dataissue.issue = issue.id           ,    field = 'version(s)_corrigée(s)' b           ,    substring(issue.entry,1,3) = 'ema'   )   group dataissue.value b

to sumarize: group uses field value alias a inside main query where field = 'point_d_effort'. however, want group field ( value alias b ) inside nested query where field = 'version(s)_corrigée(s)'.

how may that? thank you.

for more precisions ,

hi first of , want thank contributing answer here sql fiddle

http://sqlfiddle.com/#!9/610e7/1

-- query return attributes of issue

select * dataissue issue = '25998' .

what want have : 

sum(value) count(value)      field = 'version(s)_corrigée(s)'  , value  = 'fermée'   ,  field = 'point_d_effort'  , value = 'récit'  , group value field = 'version(s)_corrigée(s)'   

select  main2.value value,nbreticket,ticket   (  select dataissue.issue,dataissue.value,count(value) nbreticket,sum(value) ticket,substring(issue.entry,1,3) ,field  dataissue,issue  dataissue.issue = issue.id  , value not null , field = 'point_d_effort' , issue in ( select issue  dataissue,issue dataissue.issue = issue.id , value = 'récit'   , substring(issue.entry,1,3) = 'ema' ) , issue in ( select issue   dataissue,issue dataissue.issue = issue.id , value = 'fermée'   , substring(issue.entry,1,3) = 'ema' ) , issue in ( select issue   dataissue,issue dataissue.issue = issue.id   , field = 'version(s)_corrigée(s)' , substring(issue.entry,1,3) = 'ema' )   group dataissue.value, issue    ) main1 join  (  select  issue, `value` dataissue     field = 'version(s)_corrigée(s)'     )main2  main1.issue = main2.issue  group main2.value

in sql group clause has alias name, can't alias name group clause.

again in condition has alias name, can't alias name clause also.

in sql syntax error there. cleared errors sql running fine.

thank you.


Comments

Post a Comment

Popular posts from this blog

node.js - Using Node without global install -

i'm working on few node & electron (atom shell) projects , i'm curious how them work without user having install node globally. i've seen few applications including node directory in project contains node.exe binary. how go setting node project use binary? edit: thought should add, i've searched everywhere answer this, unrelated results.
Read more

How to access a php class file from PHPFox framework into javascript code written in simple HTML file? -

i've website developed using phpfox v3.0.7 . now i'm trying implement 'sse(server sent events)' 1 of php files. reference i'm giving below necessary code part of file. file titled process.class.php , present @ location /var/www/module/notification/include/service/process.class.php present on server having ip http://34.124.40.142/ . <?php /** * [phpfox_header] */ header('content-type: text/event-stream'); header('cache-control: no-cache'); defined('phpfox') or exit('no dice!'); /** * * * @copyright [phpfox_copyright] * @author raymond benc * @package phpfox_service * @version $id: service.class.php 67 2009-01-20 11:32:45z raymond_benc $ */ class notification_service_process extends phpfox_service { /** * class constructor */ public function __construct() { $this->_stable = phpfox::gett('notification'); } public function add($...
Read more

java - Null response to php query in android, even though php works properly -

Image
table i'm trying retrieve above data using 2 php files below. want pass email parameter , return bets user = email. work fine when tested advanced rest client, problem not php. however, when try through android 2 java classes below, null pointer exception (logcat below) , json object returned null. i'm not sure error is, think i'm not passing parameter php , that's why it's producing null response. logcat 05-31 15:10:50.227 26074-26074/com.example.albert.betterapp e/androidruntime﹕ fatal exception: main process: com.example.albert.betterapp, pid: 26074 java.lang.runtimeexception: unable start activity componentinfo{com.example.albert.betterapp/com.example.albert.betterapp.displayallbets}: java.lang.nullpointerexception @ android.app.activitythread.performlaunchactivity(activitythread.java:2292) @ android.app.activitythread.handlelaunchactivity(activitythread.java:2350) @ android.app.activitythread.acce...
Read more