table aa
(
a_id int,
a_b_code varchar(20),
a_time data,
a_memo varchar(100)
)table bb
(
b_id int,
b_code varchar(20),
b_memo varchar(100)
)取数据:
当aa 表里的 a_b_code = bb表的b_code 时
取 a_time是时间最大的一条SQL语句杂写。。?
(
a_id int,
a_b_code varchar(20),
a_time data,
a_memo varchar(100)
)table bb
(
b_id int,
b_code varchar(20),
b_memo varchar(100)
)取数据:
当aa 表里的 a_b_code = bb表的b_code 时
取 a_time是时间最大的一条SQL语句杂写。。?
select A.*,B.*
from AA as A
inner join BB AS B on A.a_b_code=B.b_code
inner join (select a_b_code,max(a_time) as a_time from A group by a_b_code) C
on A.a_b_code=C.a_b_code and A.a_time=C.a_time
--如果AA中存在a_b_code相同,a_time也相同的记录,只取一条select A.*,B.*
from AA as A
inner join BB AS B on A.a_b_code=B.b_code
where A.a_id=(select top 1 a_id from AA where a_b_code=A.a_b_code order by a_time desc,a_id desc)