Oracle－Sql语句使用笔记

一些常用的SQL语句
[color=red]一.判断在某段时间内[/color]
1）to_date
select * from table where talbe.time between to_date('2006-1-15','yyyy-mm-dd') and to_date('2008-1-15','yyyy-mm-dd') order by talbe.time;

2)trunc
select * from table where talbe.time between trunc(date(formDate) )and trunc(date(toDate) )order by talbe.time;

[color=red]二.查询匹配％[/color]
select * from table where lower(table.username) like % + username.toLower()%;

[color=red]三.如何获得前N条记录[/color]
SELECT * FROM TABLE WHERE ROWNUM<=N

[color=red]四.查看表字段的详细信息[/color]
desc table;

[color=red]五.SUM和Group[/color]
select sum(ig.gather_sum) from intend_gather ig group by ig.project_number;

[color=red]六.left join[/color]
select * from intend_gather ig left join actual_gather ag on ig.intend_id=ag.intend_id order by ig.intend_id desc