在一个SQL Server表中一行的多个列找出最大值
有时候我们需要从多个相同的列里(这些列的数据类型相同)找出最大的那个值,并显示
这里给出一个例子
IF (OBJECT_ID('tempdb..##TestTable') IS NOT NULL)DROP TABLE##TestTableCREATE TABLE##TestTable
(
IDINT IDENTITY(1,1) PRIMARY KEY,
NameNVARCHAR(40),
UpdateByApp1DateDATETIME,
UpdateByApp2DateDATETIME,
UpdateByApp3DateDATETIME)INSERT INTO##TestTable(Name, UpdateByApp1Date, UpdateByApp2Date, UpdateByApp3Date )VALUES('ABC', '2015-08-05','2015-08-04', '2015-08-06'),
('NewCopmany', '2014-07-05','2012-12-09', '2015-08-14'),
('MyCompany', '2015-03-05','2015-01-14', '2015-07-26')SELECT * FROM ##TestTable
结果如下所示