----可以查询最近日期的记录的所有个字段 select * from orderform A inner join (select companyid,max(orderdate) from orderform group by companyid) B on A.orderdate=B.orderdate and A.companyid=B.companyid
select companyid,orderdate,yewuyuan where companyid=XX客户 and orderdate=(select max(orderdate) from orderform where companyid=XX客户)
select * from orderform A inner join
(select companyid,max(orderdate) from orderform
group by companyid) B
on A.orderdate=B.orderdate and A.companyid=B.companyid
SELECT ORDERDATE=convert (smalldatetime ,orderform.orderdate)
然后再取时间最大值.
from orderform
order by orderdate desc
select top 1 *
from orderform
order by orderdate desc