SQL语句菜鸟问题,高手们进来抢分啦!!!!!
表结构如下:
CardNO IOtime TYPE
001 13:20:30 IN
002 13:25:20 OUT
002 13:26:22 IN
001 13:27:30 OUT
003 13:28:01 IN
001 13:29:56 IN
001 13:30:33 OUT
用一段Access数据库的SQL语句求出每一个编号最大时间值并且TYPE值为"IN",结果按CardNO升序排列。即按上表结果应为:
CardNO IOtime TYPE
002 13:26:22 IN
003 13:28:01 IN