Christian Bongiorno's questions

这是我的数据样本

select * from (
    select 'A' as POD, 164 as result from dual union all
    select 'A' as POD, 3 as result from dual union all
    select 'A' as POD, 2 as result from dual union all
    select 'B' as POD, 409 as result from dual union all
    select 'B' as POD, 128 as result from dual union all
    select 'B' as POD, 5 as result from dual union all
    select 'C' as POD, 12391 as result from dual union all
    select 'C' as POD, 624 as result from dual union all
    select 'C' as POD, 405 as result from dual union all
    select 'C' as POD, 26 as result from dual union all
    select 'C' as POD, 3 as result from dual union all
    select 'C' as POD, 2 as result from dual
)

我想要的是按照首次计数最高的组对它们进行排序：

我甚至不知道如何用 SQL 来表达这个

Cresult在第一行中具有最高值，然后B具有第二高值A

假设我有这个 json：

[
  {
    "first": 12355,
    "second": "abc"
  },
  {
    "first": 89010,
    "second": "def"
  },
  {
    "first": 23423,
    "second": "hij"
  },
  {
    "first": 23456,
    "second": "klm"
  },
  {
    "first": 11111,
    "second": "nop"
  }
]

我希望（一种通用形式）将它们合并为 1 个对象，其中每个键的值合并到相应值的数组中：

{
    "first" : [12355,89010,23423,23456,11111],
    "second" : ["abc","def","hij","klm","nop"]
}

我正在尝试这个，但它根本没有产生任何输出。

reduce .[] as $final (
    {};
    ((. | keys) as $k |
        map(
            ( (.[$k] // []) += ($final[$k] // []))
        )
    )
)

关注此帖子

我有这个 bash 脚本，我期望它在点击时完全终止false，但它却没有。我意识到我做的事情与链接的帖子略有不同。

#!/usr/bin/env bash
set -Eeuo pipefail

function thing() {
  false
  echo "thing1|thing2|thing3"
}
IFS='|' read -r one two three <<< "$(thing )"
echo "${one} ${two} ${three}"
echo "done"

输出：

thing1 thing2 thing3
done

理想情况下，我想在 zsh 中执行此操作，但我也遇到了我不想要的行为：

#!/usr/bin/env zsh
set -Eeuo pipefail

function thing() {
  false
  echo "thing1|thing2|thing3"
}
IFS='|' read -r one two three <<< "$(thing )"
echo "${one} ${two} ${three}"
echo "done"

输出：

  
done

如何实现这个功能？

我似乎没有找到有关此的任何文档（也许我不知道 Oracle 对此的解释），但我想创建一个接受函数的函数：比如，让它传递给我一个排序函数。

当我看到这样的代码时：

LAG(FOO) OVER (PARTITION BY XXX ORDER BY YYY) AS thing

我感觉这正是这里发生的事情 ^^ 并且OVER子句是 lambda。

可以做到吗？我这样想对吗？如果有可行的示例就更好了。