查询 最近一次的物料的价格 Date Stock Price 2010-1-1 A123 102010-2-1 A123 112010-3-1 A123 12查询出2010-3-1 A123 12 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 select top 1 * from 表 order by date desc select top 1 * from tb order by date desc select *from tbwhere convert(varchar,[date]) + stock in (select convert(varchar,max([date])) + stock from tb group by stock) select top 1 * from tb order by date desc 如果最近一次只有一笔.select top 1 * from tb order by date desc如果最近一次有多笔.select * from tb where date = (select top 1 date from tb order by date desc) with cte as( select *,row_number() over (partition by stock order by [date] desc)rn from tb)select *from ctewhere rn = 1 select * from tb a where not exists(select * from tb b where b.物料ID = a.物料ID and b.[Date] > a.[date]) select top 1 * from tb where Stock='A123' order by date desc 菜鸟求助!mysql! 系统中各对象类型的相应权限的关系数据在哪里? 关于compute查询结果的提取 update set=(其他表的字段) 如何用语句新建SQL登入用户名及设定权限 循环语句中如何把变量写入统计数据表中去 怎样得到表的行号? 有谁知道用DELPHI连接处理PB编的基于SQL anywhere 的数据库。 一个MSSQL问题,各位高手帮忙! 怎样算库存? 急!急!急!SQL查询问题,各位帮帮忙, sql注入
select *
from tb
where convert(varchar,[date]) + stock in (select convert(varchar,max([date])) + stock from tb group by stock)
select top 1 * from tb order by date desc
select top 1 * from tb order by date desc如果最近一次有多笔.
select * from tb where date = (select top 1 date from tb order by date desc)
with cte as
(
select *,row_number() over (partition by stock order by [date] desc)rn
from tb
)select *
from cte
where rn = 1
not exists(select * from tb b where b.物料ID = a.物料ID and b.[Date] > a.[date])