62,272
社区成员
发帖
与我相关
我的任务
分享求sql语句！！！！
SELECT * FROM member where language_id='30' order by reg_min and fm='images/women.gif' or fm='images/man.GIF' asc
我想实现根据reg_min 升序(desc) 根据fm降序(asc)
...全文
请发表友善的回复…
发表回复
q107770540 2010-09-27
- 打赏
- 举报
SELECT * FROM member where language_id='30' order by reg_min and fm='images/women.gif' or fm='images/man.GIF' asc
=========
SELECT * FROM member where language_id='30' and fm='images/women.gif'
order by reg_min desc,fm
=========
SELECT * FROM member where language_id='30' and fm='images/women.gif'
order by reg_min desc,fm
ybbkvi 2010-09-27
- 打赏
- 举报
SELECT * FROM member where language_id='30' and fm in('images/women.gif','images/man.GIF')
order by reg_min asc,fm desc
order by reg_min asc,fm desc
王向飞 2010-09-27
- 打赏
- 举报
给出测试数据 和你需要的结果形式。，
SELECT * FROM member where language_id='30'
order by reg_min desc,fm asc
