Skip to content
Advertisement

Can row_number() ignore null in oracle

I have data like this

How can i write query to get row_number without counting null column.

Advertisement

Answer

Well, not specifically. But you can get what you want by using conditional logic:

It is not clear to me what the order by is for the row_number() which is what the . . . means.

User contributions licensed under: CC BY-SA
3 People found this is helpful
Advertisement