mysql - 选择最大值并选择其他列

Question

我试图从一列中获取 max + 1 值，并从另一列中获取所有值。但是，我的查询没有给出任何结果。

例如，

 SectionItemID   SectionItem
 1                    blue
 2                    red

查询应该返回

SectionItemID    SectionItem
3                    blue
                     red

这是我的

SELECT SectionItem,MAX(SectionItemID) + 1 AS SectionItemID FROM Core.SectionItem_Lkup 

Answer 1

SELECT SectionItem,
       (select MAX(SectionItemID)+1 FROM Core.SectionItem_Lkup) AS SectionItemID
FROM Core.SectionItem_Lkup