常用sql

[b]日期转换[/b]

update promotion set end_time=to_date('2010-10-15 23:59:59','yyyy-MM-dd HH24:mi:ss') where id=33151

select * from kyds_vote v where v.createtime>to_date('2011-11-13','yyyy-MM-dd') order by v.id desc

[b]HAVING 用来从分组的结果中筛选行[/b]

select * from order_ticket ot Where ot.ticket_id In (select ot.ticket_id from order_ticket Group By ot.ticket_id Having Count(*)>1) order by ot.ticket_id

HAVING 百科：[url]http://baike.baidu.com/view/1265760.htm[/url]

[b][color=darkblue]w3school sql[/color][/b]：[url]http://www.w3school.com.cn/sql/sql_union.asp[/url]