1 Reply Latest reply: Nov 7, 2018 12:30 AM by Than Mughi RSS

    get next values if NULL

    Chia Jia Xiang

      Hi all,

       

       

      Table 1:

      EMPLIDSTRMGPA
      115200.000
      115303.750
      116103.940
      116203.940
      116304.040
      117104.040
      118103.400
      118203.400
      11830NULL

       

       

       

      This will be done in the loading script. What i want to be able to do is to get the GPA from MAX(STRM)  if it is not null.

       

      Let me elaborate. If there is a value in 1830 , then pick up the GPA from there.

      In this scenario, where the GPA in the highest STRM 1830 is null, i want to be able to get the GPA of 3.400 from STRM 1820.

       

      Desired Output:

      EMPLID      STRM      GPA

      1                   1820       3.4

       

      Any form of help is greatly appreciated.

       

      Thank you for your time!