17 January 2024
Replymessage unavailable
why do you participate for giving such fake documentation ?
and you make money by such fake business..
you are really brave to do such business in public group.. great yaar..
till today how many fake document you have made ?
Automation Lifewhy do you participate for giving such fake documentation ?
and you make money by such fake business..
you are really brave to do such business in public group.. great yaar..
till today how many fake document you have made ?
Neither they make any fake documents nor they give fake documents. Their target is to loot the money from the people by the name of documents.
SuneelNeither they make any fake documents nor they give fake documents. Their target is to loot the money from the people by the name of documents.
True.. many people have said me, after they take money they never respond
select (select m3.bal
from tlm_gt_custom m3
where m3.acc = m1.acc
and m3.ccy = m1.ccy
and trunc(m3.val_dt) >= trunc(add_months(sysdate, -1), 'MM')
and rownum = 1) begining_of_month
from tlm_gt_custom m1 where m1.ccy = 'USD'
and m1.acc = '9820084080783001'
group by m1.ccy, m1.acc
How to display 0 if there is no data in the above query
Siddhantselect (select m3.bal
from tlm_gt_custom m3
where m3.acc = m1.acc
and m3.ccy = m1.ccy
and trunc(m3.val_dt) >= trunc(add_months(sysdate, -1), 'MM')
and rownum = 1) begining_of_month
from tlm_gt_custom m1 where m1.ccy = 'USD'
and m1.acc = '9820084080783001'
group by m1.c
In no data place , if you get nulls then you can use nvl function
SiddhantI have used nvl but it's not displaying 0
SELECT NVL((SELECT m3.bal
FROM tlm_gt_custom m3
WHERE m3.acc = m1.acc
AND m3.ccy = m1.ccy
AND TRUNC(m3.val_dt) >= TRUNC(ADD_MONTHS(SYSDATE, -1), 'MM')
AND ROWNUM = 1), 0) AS beginning_of_month
FROM tlm_gt_custom m1
WHERE m1.ccy = 'USD'
AND m1.acc = '9820084080783001'
GROUP BY m1.ccy, m1.acc;
SiddhantYes it should print 0 but don't knw why it's not printing
you can use other way to have NULL values
Automation LifeSELECT NVL((SELECT m3.bal
FROM tlm_gt_custom m3
WHERE m3.acc = m1.acc
AND m3.ccy = m1.ccy
AND TRUNC(m3.val_dt) >= TRUNC(ADD_MONTHS(SYSDATE, -1), 'MM')
AND ROWNUM = 1), 0) AS beginning_of_month
FROM tlm_gt_custom m1
WHERE m1.ccy =
SELECT COALESCE(
(SELECT m3.bal
FROM tlm_gt_custom m3
WHERE m3.acc = m1.acc
AND m3.ccy = m1.ccy
AND TRUNC(m3.val_dt) >= TRUNC(ADD_MONTHS(SYSDATE, -1), 'MM')
AND ROWNUM = 1), 0) AS beginning_of_month
FROM tlm_gt_custom m1
WHERE m1.ccy = 'USD'
AND m1.acc = '9820084080783001'
GROUP BY m1.ccy, m1.acc;
SiddhantNot working bro
no this is not the way.. you will have explain whats the error you are getting
Automation LifeSELECT COALESCE(
(SELECT m3.bal
FROM tlm_gt_custom m3
WHERE m3.acc = m1.acc
AND m3.ccy = m1.ccy
AND TRUNC(m3.val_dt) >= TRUNC(ADD_MONTHS(SYSDATE, -1), 'MM')
AND ROWNUM = 1), 0) AS beginning_of_month
FROM tlm_gt_custom m1
WH
SELECT COALESCE(m3.bal, 0) AS beginning_of_month
FROM tlm_gt_custom m1
LEFT JOIN tlm_gt_custom m3 ON m3.acc = m1.acc
AND m3.ccy = m1.ccy
AND TRUNC(m3.val_dt) >= TRUNC(ADD_MONTHS(SYSDATE, -1), 'MM')
WHERE m1.ccy = 'USD'
AND m1.acc = '9820084080783001'
GROUP BY m1.ccy, m1.acc, m3.bal;
Automation Lifei am not getting your query.. are you asking which SQL server ?
I want to know which tool do you use for making SQL queries
BTI want to know which tool do you use for making SQL queries
use normal note pade or VS code or you can directly type in workbench