sql语句总结

oracle下的，还不清楚oracle下与mysql有什么区别

1.简单语句：

select  * from wpps_nwp_deal_dr ;

insert into wpps_nwp_deal_dr  ID,date values(1,'1985-02-23');

update wpps_nwp_deal set date='1985-02-23' where ID=1;

2.曾经用过的语句总结分析：

按时间排序，取出最新的三条记录

select * from (select * from wpps_nwp_deal_dr order by to_date(GET_DATE,'YYYY-MM-DD') desc,to_date(GET_TIME,'HH24:MI:SS') desc)
where rownum <=3;