3 Replies Latest reply on Jul 27, 2018 5:49 AM by Zhouyi Zhang

    How to find out min value and 2nd min value with null value

    Gaurav Baghel

      hello to everyone

      this data set is sample which contain  Column (Sr.No, Name, A,B,C,D)

      the values in A B C D column are numeric as well as null values i need

      output like min values & second min values at this manner which are shown in

      sample data set (in yellow column).

      Thank You

      Sr. No
      Name
      A
      B
      C
      D
      1aaanull10020050
      2bbb200 100null500
      3 cccnullnull50100
      4ddd100null200300
      5eee50302040
      6fff5060nullnull
      7ggg70null80null
      8hhhnull90null100
      9iii200210nullnull
      10jjj200nullnullnull

       

       

       

      above data set is given with null value i just want min value and 2nd highest min value

       

       

       

      No
      Name
      A
      B
      C
      D
      MIn Value
      2nd Highest Min Value
      1aaanull1002005050100
      2bbb200 100null500100200
      3 cccnullnull5010050100
      4ddd100null200300100200
      5eee503020402030
      6fff5060nullnull5060
      7ggg70null80null7080
      8hhhnull90null10090100
      9iii200210nullnull200210
      10jjj200nullnullnull200null

       

       

      Kindly help me out.