select max(data) from tbl where data between(data1 ,data2); 好想是这样的啊!
解决方案 »
- Iterator iterator = SessionListener.getSet();提示错误???
- struts2 <s:optiontransferselect>有下拉的滚动条,但是没有左右滚动条,请问怎么加?
- 谁有类似于CSDN提示框消息的源代码吗?
- servlet与class
- 请大家帮我解决JSP 连接 ORACLE10G的问题???
- javabean的问题
- 各位,你认为最好的JSP书是……
- web组件不显示问题
- 关于spring 4 scheduled tasks 嵌入 web 容器的配置
- 最近在学习HTML,整理了些资料,希望对学习HTML的朋友有所帮助
- 98+jb5+IE如何定义和编写html(jsp)的网站应用,jb5中不能创建纯html页并运行吗?
- jsp中的数组传送问题,好久的了
FROM t_time
WHERE time >= '2002-01-11' AND time <= '2002-01-15'
EXEC SQL SELECT TOP 1 NMJ_KANJKMK,KBN_IKAT_KEIJO
FROM RFM006D0
WHERE YMD_YUKO_KIKN_STAT <= '02-01-01' AND YMD_YUKO_KIKN_FNSH >= '01-01-01'
ORDER BY YMD_YUKO_KIKN_STAT DESC;
create table test (a date, b number(5));
insert into test values(to_date('2001-01-14','yyyy-mm-dd'),1);
insert into test values(to_date('2001-01-15','yyyy-mm-dd'),2);
insert into test values(to_date('2001-01-16','yyyy-mm-dd'),5);
insert into test values(to_date('2001-01-17','yyyy-mm-dd'),4);
insert into test values(to_date('2001-12-17','yyyy-mm-dd'),3);
commit;
select * from test
where a = (
select max(a) from test
where a>=to_date('2001-01-14','yyyy-mm-dd')
and a<=to_date('2002-01-01','yyyy-mm-dd')
);