0,
0,
( round (NVL (NVL ( sum (a.R EGISTER_COUNT), + 0)
NVL ( sum (a.X CYY), 0),
0)/ sum (a.S UMREGISTER_COUNT),
4))) * 100 | | '%'
booking rate
CodePudding user response:
SELECT the booking rate=the CONVERT (
VARCHAR,
In CASE the SUM (a.S UMREGISTER_COUNT)
THEN the WHEN 0
0
The WHEN ROUND (
ISNULL (ISNULL (SUM (REGISTER_COUNT), 0) + ISNULL (SUM (a.X CYY), 0), 0)
/SUM (a.S UMREGISTER_COUNT),
4
) THEN
The SUM (a.S UMREGISTER_COUNT)
END * 100
) + '%'.
Almost is such, reference
CodePudding user response:
thank you issue has been resolved,CodePudding user response:
