根据列的最新值以及其他谓词查找

Question

我有一个模式如下:

Products(name, company_id, version)

添加一些虚拟数据:

<表类>名称company_id版本tbody><<tr>11b1112c2121

使用TOP，我们可以尝试:

SELECT TOP 1 *
FROM Products
WHERE name = 'a' AND company_id = 1
ORDER BY version DESC;

获取表中所有公司的最新版本:

SELECT TOP 1 WITH TIES *
FROM Products
WHERE name = 'a'
ORDER BY ROW_NUMBER() OVER (PARTITION BY company ORDER BY version DESC);

SELECT TOP 1 P.*
FROM PRODUCTS AS P
WHERE P.name = 'A' AND P.company_id = 2
ORDER BY P.version DESC

我想，你可以试试这个