If there are not too many priotities, you can use this one:
I "create" a temporyry table wih all priorities.
from TTABLE TT,
WHEN rownum = 1
WHEN rownum = 2
WHEN rownum = 3
END AS PRIORITY
WHERE rownum <=3
WHERE FILLER.PRIORITY = TT.PRIORITY ( + )
GROUP BY FILLER.PRIORITY
Or you create a real table with only one column with all priorities.
This forum is ONLY for Sql Developer questions/issues.
Please mark the thread ANSWERED and repost your question in the SQL and PL/SQL forum.
However I want to display value in this format:
So also I want to display the count of priority 2 though it has no value.
Can any one help me how to get this value.
Why? Why would you want to display the WRONG results?
There are no rows with priority 7 so that should be in the result also 0 - 7.
And there are no 6s, 8s, 23s, 874s, etc - there are an INFINITE number of possible priorities for which there is no value. Shouldn't they all be included? There is NOTHING to indicate that '2' is the ONLY priority that COULD BE possible.
Post in the correct forum and provide ALL of the info needed to help - please do NOT follow up here.