数字最高的环回findone

使用 FETCH FIRST 结合 ORDER BY 要查找版本号最高的行:

select * from tablename
order by version_number desc
fetch first 1 row only

尝试以下操作:

SELECT * FROM table t where 
   version_number IN (select max(version_number) from table v)

我会这样做:

const findMax = (model, field) => {
  return new Promise((resolve, reject) => {
    model.find({
      order: `${field} DESC, id ASC`
    }, (err, rows) => {
      if (err) return reject(err);
      resolve(rows.filter(row => row[field] === rows[0][field]));
    });
  });
}

作为一种远程方法,钩子,中间件,任何适合您需要的东西。