Question

sql语句:请问下面这sql怎么往上加排序(降序)以时间为降序?

"select count(refund_id) from refund where refund_audit=1 and f_user_uid ='" + userid + "'";

Answer 1

你这样查询出来就一个 符合你条件的记录数
没办法排序啊？
如果打算按梁芹时间排序就别查个数了。。
select refund_id,addtime from refund where refund_audit=1 and f_user_uid ='" + userid + "'
order by addtime desc
//按时竖渣庆余握间倒叙

Answer 2

你现在查询是符合辩脊闹条件的记录总数野扒 不必要去排序！
除非你还想查询其他数携罩据 可以加
如"select count(refund_id), refund_id from refund where refund_audit=1 and f_user_uid ='" + userid + "' order by 时间字段 desc Group by refund_id ";

Answer 3

select count(refund_id) from refund where refund_audit=1 and f_user_uid ='" + userid + "' order by 字扮梁尘让段厅兄运 desc

Answer 4

你这个sql还怎么加升降序啊， count（）返回的是结果的行数，只是一个数字，怎么升降序啊