Sql Help........

[ilovekajal]

Count stetement lo Case statement vadali case statement lo 3 conditions unnayi and oka cont vale undhi so syntax ela rayali .nenu koni try chesanu kani error vasthondhi...................

[Basavayya]

Help

[Basavayya]

[font="courier"][size="2"]Online Choosa Bayya. Hope this helps:

select count(case when checked = 0 then messageFromID else NULL end) as OutboundMessages_UnChecked,count(case when checked = 1 then messageFromID else NULL end) as OutboundMessages_checked,
count(messageFromID) as OutboundMessages_total
FROM tblMessage
WHERE messageFromID = 1000[/size][/font]

[taarachowdary]

[quote name='TITANIC' timestamp='1343330113' post='1302205465']
Count stetement lo Case statement vadali case statement lo 3 conditions unnayi and oka cont vale undhi so syntax ela rayali .nenu koni try chesanu kani error vasthondhi...................
[/quote]
inner query vadithe better unless huge data ayyithe thappa

Give more details

[Avataar]

inka nayam TiTANIC sequel Anukunna...!!! kaaju

[madathakaaja]

[ganesh]

select count(case when condition then ' ' when condition then ' ' else ' ' end) from

[ilovekajal]

COUNT( case when DETAIL_POSITION IS NULL then 1 else 0 END
when NVL(A.sample_drop_qty,0) <> 0 then 1 else 0 END
when (PROMO_DROP_QTY IS NULL OR PROMO_DROP_QTY = 0 ) then 1 else 0 END
A.CALL_HEADER_ID) AS CALL_CNT



idhi bhayya asalu query........

[ilovekajal]

HELP PLS.........

[badboy7]

error emi ani vasthundi kaja...

[Vivian_afdb]

lttt

[badboy7]

[quote name='Vivian_afdb' timestamp='1343334248' post='1302205839']
lttt
[/quote]
endi neeedi sql aa?

[Vivian_afdb]

[quote name='badboy7' timestamp='1343334312' post='1302205847']
endi neeedi sql aa?
[/quote]


Helping titanic

[ChampakDas]

ardam elle. Can you elucidate it more clearly?

[ghazni]

[quote name='TITANIC' timestamp='1343330623' post='1302205511']
COUNT( case when DETAIL_POSITION IS NULL then 1 else 0 [color=#FF0000]END[/color]
when NVL(A.sample_drop_qty,0) <> 0 then 1 else 0 END
when (PROMO_DROP_QTY IS NULL OR PROMO_DROP_QTY = 0 ) then 1 else 0 END
A.CALL_HEADER_ID) AS CALL_CNT



idhi bhayya asalu query........
[/quote]
end anedi last lo ravali kada nuventi prati daniki petav