i have following postgresql query:          (           select '201405mase04' testid, count(*) totq, count(distinct case when se1 = '' null else se1 end) totse,                   case when count(*)=0 7 else count(distinct rc) end totrc           eivtestitems ti, eivtests t            ti.test_id = t.test_id                   , t.test_type_id = 1                  , t.test_id=  '201405mase04'                  , ti.omit <> 1    ),     b     (           select '201405mase04' testid, count(*) totq           eivtestitems ti, eivtests t            ti.test_id = t.test_id                   , t.test_type_id = 1                  , t.test_id=  '201405mase04'                  , ti.omit = 1    ),    c    (           select '201405mase04' testid, count(*) totq           eivtestitems ti, eivtests t            ti.test_id = t.test_id                   , t.test_type_id = 1                  , t.test_id=  '201405mase04'                  , ti....
 
Comments
Post a Comment