cmd.CommandText = "Select * From (Select Row_Number() Over(Order by a.序号 desc) As [NO.],[_Identify],a.药品名称,a.生产厂家,a.规格,整盒库存 From {咨询记录} as a inner join (select 药品名称,生产厂家,规格,max(序号) as 序号 from {咨询记录} group by 药品名称,生产厂家,规格) as b on a.药品名称 = b.药品名称 and a.生产厂家=b.生产厂家 and a.规格 = b.规格 and a.序号=b.序号 where 用户名 ='" & e.Cookies("username") & "') As a "
加好友 
发短信
Post By：2019/11/12 9:14:00 [显示全部帖子]
