mysql - Sub query with count -

-

this query works fine , list of (male,female) items.

select dmg.dmg_sex demographic dmg join link lnk on lnk.lnk_dmgid = dmg.dmg_id join admission adm on adm.adm_id = lnk.lnk_admid adm.adm_id in (select distinct(adm.adm_id)                      admission adm                      join link lnk on lnk.lnk_admid = adm.adm_id                      join daily_link dlnk on dlnk.dlk_lnkid = lnk.lnk_id                       dlnk.dlk_assessdate >= '2011/01/01' , dlnk.dlk_assessdate <= '2011/03/31')

if male, female result in counted list

select dmg.dmg_sex, count (dmg.dmg_sex) demographic dmg join link lnk on lnk.lnk_dmgid = dmg.dmg_id join admission adm on adm.adm_id = lnk.lnk_admid adm.adm_referraldate >= '2011/01/01' , adm.adm_referraldate <= '2011/03/31' group dmg.dmg_sex desc

but trying combine 2 queries adding count (dmg.dmg_sex) first query not work. why or missing something

select dmg.dmg_sex, count (dmg.dmg_sex) demographic dmg join link lnk on lnk.lnk_dmgid = dmg.dmg_id join admission adm on adm.adm_id = lnk.lnk_admid adm.adm_id in (select distinct(adm.adm_id)                      admission adm                      join link lnk on lnk.lnk_admid = adm.adm_id                      join daily_link dlnk on dlnk.dlk_lnkid = lnk.lnk_id                       dlnk.dlk_assessdate >= '2011/01/01' , dlnk.dlk_assessdate <= '2011/03/31')

desired output

male 243
female 183

output getting now

male
male
male
male
male
male
female
female
female
female
female
female
female

to able count sex need following sql combine sql 

group dmg.dmg_sex desc

Comments

Post a Comment

Popular posts from this blog

Android : Making Listview full screen -

-
<linearlayout xmlns:android="http://schemas.android.com/apk/res/android" xmlns:tools="http://schemas.android.com/tools" android:layout_width="match_parent" android:layout_height="match_parent" android:orientation="vertical" tools:context=".mainactivity"> <edittext android:layout_margintop="5dp" android:layout_width="match_parent" android:layout_height="50dp" android:background="@drawable/location_edittext" android:id="@+id/locationeditext" android:textsize="15sp" android:textcolor="#999" android:paddingleft="15dp" /> <com.example.ravi_gupta.slider.viewpagercustomduration android:layout_width="wrap_content" android:layout_height="0dp" android:id="@+id/viewpager" android:scrollbarstyle="outsideoverlay" android:layout_weight="0.5...
Read more

javascript - Parse JSON from the body of the POST -

-
i'm using cameratag.com record video on website. service can send json response server can save data database. don't know how proceed here: the documentation states please note json repsonse passed in body of post , not form parameters. here example of how parse response in ruby: data = json.parse(request.raw_post) video_uuid = data["uuid"] but don't know how data on javascript. i'm not experienced in js please bare me :) post sample: { "uuid": "00012710-4b65-0131-ffe6-22000a499ea4", "camera_uuid": "98373a20-79ee-0130-3e42-1231390fcc11", "created_at": "2013-12-20t05:25:02.000z", "percent_complete": 100, "short_code": "kktb4q", "metadata": { }, "state": "published", "recorded_from": "http://singwho.com", "publish_type": null, "formats": [ { "name...
Read more

javascript - How to Hide Date Menu from Datepicker in yii2 -

-
basically in datetimepicker widget date choose first time, how can hide date option widget , filter according time. tried not working want hide remove button [ 'attribute'=>'time', 'label'=>'time', 'format'=>'raw', 'value'=>function($data){ return date('h:i:s',strtotime($data->time)); }, 'filter'=> datetimepicker::widget([ 'model' => $searchmodel, 'attribute' => 'time', 'clientoptions' => [ 'autoclose' => true, 'format' => 'hh:ii', 'showon' =...
Read more