Framework & Experience (Infrastructure, Cloud, Integration, Dev Tools) | IFS Community
  • 3,728 Topics
  • 13,151 Replies

3728 Topics

find next higher number based on certain where-conditions (SQL)

Hi all,sorry, this is more of a general SQL question. I have to find the next higher sequence-number depending on certain where-conditions:Table-example:╔═══════╦══════════════════╦═══════════════════════════╗║  Seq    ║       Start_Time       ║             Queue           ║╠═══════╬══════════════════╬═══════════════════════════╣║ 34962 ║ 28.07.2020 17:06 ║ PQ_NEW PRICE REQUEST GMDM ║║ 35393 ║ 29.07.2020 11:03 ║                           ║║ 35394 ║ 29.07.2020 11:03 ║                           ║║ 42886 ║ 04.09.2020 14:16 ║ PQ_NEW PRICE REQUEST GMDM ║║ 42887 ║ 04.09.2020 14:16 ║ PQ_NEW PRICE REQUEST GMDM ║║ 42888 ║ 04.09.2020 14:16 ║                           ║║ 42889 ║ 04.09.2020 14:16 ║                           ║║ 42890 ║ 04.09.2020 14:17 ║ PQ_COST SWEDEN            ║║ 42891 ║ 04.09.2020 14:17 ║ PQ_COST SWEDEN            ║║ 42892 ║ 04.09.2020 14:17 ║                           ║║ 42893 ║ 04.09.2020 14:17 ║                           ║║ 42894 ║ 04.09.2020 14:17 ║ PQ_NEW PRICE REQUEST GMD

Badges

Show all badges