带你深入了解如何根据数据库时间戳选择列 数据库开发
关键字:问题:我在工作中遇到了难题,一列数据,除了时间戳以外别的都一样,谁能告诉我,应该如何来选择?
解答:
--假如知道timestamp的值
select * from table where timestamp = 0x00000000000007EA
--不知道值
--第二列
select top 1 * from table where timestamp not in (select top 1 timestamp from table )
--第三列
select top 1 * from table where timestamp not in (select top 2 timestamp from table )
--第四列
select top 1 * from table where timestamp not in (select top 3 timestamp from table )