如图，注释的代码第一行显示我写的不完整，我想排序重复次数最多的

贴代码好看点

clear
do case
case thisform.optiongroup1.option1.value=1
     select * from 车辆表 order by 应收押金 into cursor temp
     thisform.grid1.RecordSource = 'temp'
case thisform.optiongroup1.option2.value=1
     select * from 车辆表 order by 日租金 into cursor temp
     thisform.grid1.RecordSource = 'temp'
case thisform.optiongroup1.option3.value=1
     select * from 车辆表 order by 超时 into cursor temp
     thisform.grid1.RecordSource = 'temp'
case thisform.optiongroup1.option4.value=1
*!*         SELECT 车辆名称 count( * ) AS count from 租借表
*!*         GROUP BY 车辆名称
*!*         ORDER BY count DESC into cursor tmp
*!*         thisform.grid1.RecordSource='temp'
endcase
thisform.refresh

写代码要看表中的数据

除了图片是通用型，其他的为了简便都是字符型