sql - multiple query same table but in different columns mysql -

-

i'm trying more columns summarizing result 2 different tables

set @start_res = 20150301; set @finish_res= 20150501; set @finish_check= 20150801; set @start_check= 20150301; set @daily_hos= 3;  select*    ( select count(day_in) arr t_hospital day_in between  @start_check , @finish_check , res_date between @start_res , @finish_res  , id_daily_hos =@daily_hos group day_in  )e,      (select count(pat_status) ong1 t_hospital pat_status  '%ong%' ,  day_in between @start_check , @finish_check , res_date between @start_res , @finish_res  , id_daily_hos =@daily_hos group day_in ) a,         (select count(pat_status) rted t_hospital pat_status  '%rtde%'and  day_in between  @start_check , @finish_check , res_date between @start_res , @finish_res  , id_daily_hos =@daily_hos group day_in  )b,            (select count(pat_status) poli t_hospital pat_status  '%pol%'and day_in between @start_check , @finish_check , res_date between @start_res , @finish_res  , id_daily_hos =@daily_hos group day_in   )c,               (select count(pat_status) para t_hospital pat_status  '%para%' ,  day_in between @start_check , @finish_check , res_date between @start_res , @finish_res  , id_daily_hos =@daily_hos group day_in  )d

and of course not work, first displayed column (arr) works while other ones show wrong output.

where wrong?

this pretty common pattern:

select day_in, count(*) arr,         sum(if(pat_status  '%ong%', 1, 0)) ong1,         sum(if(pat_status  '%rtde%', 1, 0)) rted,         sum(if(pat_status  '%pol%', 1, 0)) pol1,         sum(if(pat_status  '%para%', 1, 0)) para t_hospital  day_in between @start_check , @finish_check      , res_date between @start_res , @finish_res       , id_daily_hos =@daily_hos group day_in

Comments

Post a Comment

Popular posts from this blog

r - how do you merge two data frames the best way? -

-
i need merge data.frame s: dput(data) structure(list(hostname = structure(c(8l, 8l, 9l, 5l, 6l, 7l, 1l, 2l, 3l, 4l), .label = c("db01", "db02", "farm01", "farm02", "tom01", "tom02", "tom03", "web01", "web03"), class = "factor"), date = structure(c(6l, 10l, 5l, 3l, 2l, 1l, 8l, 9l, 7l, 4l ), .label = c("10/5/2015 1:15", "10/5/2015 1:30", "10/5/2015 2:15", "10/5/2015 4:30", "10/5/2015 8:30", "10/5/2015 8:45", "10/6/2015 8:15", "10/6/2015 8:30", "9/11/2015 5:00", "9/11/2015 6:00"), class = "factor"), cpubusy = c(31l, 20l, 30l, 20l, 18l, 20l, 41l, 21l, 29l, 24l), usedpercentmemory = c(99l, 98l, 95l, 99l, 99l, 99l, 99l, 98l, 63l, 99l)), .names = c("hostname", "date", "cpubusy", "usedpercentmemory"),
Read more

How to debug "expected android.widget.TextView but found java.lang.string" in Android? -

-
can please take @ code? trying build app personal school project. new android studio. have put simple app display spaces available in parking lot. but trying open second activity screen when click on 1 of lots in listview screen. got error , have no way of solving it. **mainactivity.java** <?xml version="1.0" encoding="utf-8"?> <relativelayout xmlns:tools="http://schemas.android.com/tools" android:layout_width="fill_parent" android:layout_height="fill_parent" > <textview android:id="@+id/lotname" android:layout_width="wrap_content" android:layout_height="wrap_content" /> <textview android:id="@+id/lotspaces" android:layout_width="wrap_content" android:layout_height="wrap_content" android:layout_below="@+id/lotname"/> </relativelayout> **singlelotview.java** package com.example.sahan.smart
Read more

php - mySQL problems with this code? -

-
i having problems code , hoping can help. basically have issue whereby mysql running out of connections when script run hundreds of times in sequence. https://gist.github.com/anthonyts/b6c46d54ee8bf2d714b8 here database class: https://gist.github.com/anthonyts/89f5a831e31d970fb5e1 here error get: e_error: call member function query() on non-object stack trace: in db::single called @ /var/www/html/scripts/stalk/db.php (68) in db::single called @ /var/www/html/scripts/stalk/beanstalk_check_monitoring_logs.php (88) in {closure} called @ /var/www/html/application/libraries/stalk.php (80) in stalk::background called @ /var/www/html/scripts/stalk/ beanstalk_check_monitoring_logs.php (188) you should put db initialization: $con = mysql_connect(db_host, db_user, db_pass); mysql_select_db(db_database); $db = new db(db_host, db_user, db_pass, db_database); above your: $stalk = new stalk(array(beanstalkd_server, beanstalkd_port)); on top of script, create
Read more