如何在ACCESS中查找最大值

id no spid spname
23 100510123456001 797 辣椒
24 100510123456002 797 辣椒
25 100510654321001 797 辣椒
26 100510654321002 797 辣椒

如何用SQL语句找出no前几位为100510123456的最大no
no为文本型

select max(no) from table where no like '*100510123456*'

select * from table where no alike '100510123456%'

select table_data.time, max(table_data.date) as date之最大值 from table_data group by table_data.time;