标题：找每种产品列最后一条问题

1楼

lin98 发表于：2023/11/4 16:24:00

Dim ld As Date

Dim cmd As New SQ-LCommand

cmd.C

cmd.CommandText = "Selec-t top 1 日期 From {订单} Where 产品 = '?' Order by 日期 Desc"

ld = cmd.ExecuteScalar()

找每种产品列最后一条,每种产品产品 = '?',不行

2楼

有点蓝 发表于：2023/11/4 16:38:00

cmd.CommandText = "Select 产品, max(日期) as 日期 From {订单} group by 产品"

dim dt as datatable = cmd.ExecuteReader()

共2 条记录, 每页显示 10 条, 页签: [1]