有一张表
_________________________________________________________
| 编号 | 点击 | 点击时间 | 时间 | 会员级别 |
_________________________________________________________
| 1 | 1 | 20009-10-11 | 20009-10-10 | 1 |
_________________________________________________________
| 2 | 1 | 20009-10-16 | 20009-10-11 | 2 |
_________________________________________________________
| 3 | 0 | 20009-10-14 | 20009-10-05 | 3 |
_________________________________________________________
| 4 | 1 | 20009-10-15 | 20009-10-02 | 4 |
_________________________________________________________
先查会员级别,排序,然后查是否点击,排序,然后查点击时间,按照点击时间排序,最后查询数据添加时间排序
_________________________________________________________
| 编号 | 点击 | 点击时间 | 时间 | 会员级别 |
_________________________________________________________
| 1 | 1 | 20009-10-11 | 20009-10-10 | 1 |
_________________________________________________________
| 2 | 1 | 20009-10-16 | 20009-10-11 | 2 |
_________________________________________________________
| 3 | 0 | 20009-10-14 | 20009-10-05 | 3 |
_________________________________________________________
| 4 | 1 | 20009-10-15 | 20009-10-02 | 4 |
_________________________________________________________
先查会员级别,排序,然后查是否点击,排序,然后查点击时间,按照点击时间排序,最后查询数据添加时间排序
么意思
???
order by 会员级别 asc,点击 desc, 点击时间 desc, 时间 asc??
set @sql='select * from order by'
if ……
set @sql=@sql+'会员级别'
if ……这样?
*
from
tb
order by
会员级别 asc,点击 desc, 点击时间 desc, 时间 asc