title: sql query to find second not null value in a table (oracle)
body: <p>I have have a table which has n columns with n columns.Some of the column name are as follows</p>
  
  <pre><code>c, c2,c3,c4,c5  , c25
  
  sample data
  c1    c2     c3   c4  c5  (consider only 5 in this case)
  x     y      z    z  y
  x     y
  x
  a     b     j     k
  a     c      g    h  i
  k     l      m    n  o
  </code></pre>
  
  <p>Now op   = second not null value from right side
  sample op for above data</p>
  
  <pre><code>z
  x
  x  (special case as no data left of x)
  j
  h
  n 
  </code></pre>
  
  <p>Cannot use COALESCE ad i need second not null not first</p>
  
  <p>Can someone help me with this query</p>