Forum Discussion

carlosarmpb's avatar
carlosarmpb
Frequent Visitor
8 years ago
Solved

Filter only the second highest value

I need a simple thing.

Fillet only the second highest value of this query.

NOTE: I need this in the Query Editor.

CODE DATE
10001 21/10/2018
10001 01/09/2018
10002 26/08/2018
10002 16/10/2018
10003 31/08/2018
10003 04/09/2018
10004 13/10/2018
10004 17/09/2018
10005 06/10/2018
10005 11/09/2018
10006 23/08/2018
10006 22/08/2018
10007 26/10/2018
10007 06/09/2018
10008 02/10/2018
10008 03/09/2018
10009 02/09/2018
10009 08/10/2018
10010 07/09/2018
10010 25/10/2018

Need Help

5 Replies

  • parry2k's avatar
    parry2k
    Super User
    8 years ago

    not sure I understood, what you expect the result to be?

    • parry2k's avatar
      parry2k
      Super User
      8 years ago

      is this the result you are looking for?

       

    • carlosarmpb's avatar
      carlosarmpb
      Frequent Visitor
      8 years ago

      The idea is to get the code returned and the second largest date.

      CODE DATE
      10001 01/09/2018
      10002 26/08/2018
      10003 31/08/2018
      10004 17/09/2018
      10005 11/09/2018
      10006 22/08/2018
      10007 06/09/2018
      10008 03/09/2018
      10009 02/09/2018
      10010 07/09/2018