方法一、根据时间倒序排序,添加行号
select ksno,xuliehao,print_time,id,tjxx,create_time,print_status from(
SELECT
ksno,xuliehao,print_time,id,tjxx,create_time,print_status,row_number() over
(
order by create_time desc
) num
FROM
tj_querenbiao
) a where a.num=1;
方法二:获取最新时间,根据最新时间获取数据
select ksno,xuliehao,print_time,id,tjxx,create_time,print_status from tj_querenbiao where create_time= (select max(create_time) from tj_querenbiao);
方法三:使用top 1获取第一条数据
select top 1 version from tj_querenbiao where ksno=(select top 1 ksno from tj_querenbiao where version='1851010111052520190216100221') ORDER BY create_time desc;