select * from (select * from where INPUTDATE<(select INPUTDATE from table where itemid=3) order by INPUTDATE desc) a where rownum<=2;
select * from (select * from where INPUTDATE<(select INPUTDATE from table where itemid=3) order by INPUTDATE desc) a where rownum<=2 union all select * from (select * from where INPUTDATE<(select INPUTDATE from table where itemid=5) order by INPUTDATE desc) a where rownum<=2
粗心大意!!!select * from (select * from table where INPUTDATE<(select INPUTDATE from table where itemid=3) order by INPUTDATE desc) a where rownum<=2 union all select * from (select * from table where INPUTDATE<(select INPUTDATE from table where itemid=5) order by INPUTDATE desc) a where rownum<=2把相应的表名替换
楼上的还是不行 报ORA-01427: single-row subquery returns more than one row
select * from (select * from (select * from testone where itemid<3 order by itemid desc) where rownum<=2) union all (select * from (select * from testone where itemid<=5 order by itemid desc) where rownum<=2);你把相应的表名替换吧,我试过了,可以的
select * from (select * from table_name where itemid=3 order by inputdate desc) where rownum<3 union select * from (select * from table_name where itemid=5 order by inputdate desc) where rownum<3将表名table_name替换了在用,可能中间有敲错的,自己纠错吧
明白了,select INPUTDATE from table where itemid=3 与 select INPUTDATE from table where itemid=5在表内已超过一条记录,当然报错select ITEMID,CONTENT,CHINESE from table group by ITEMID,CONTENT,CHINESE hvaing count(itemid)<=2 order by INPUTDATE desc;请楼主测试!
明白了,select INPUTDATE from table where itemid=3 与 select INPUTDATE from table where itemid=5在表内已超过一条记录,当然报错select ITEMID,CONTENT,CHINESE from table group by ITEMID,CONTENT,CHINESE hvaing count(itemid)<=2 order by INPUTDATE desc;不知是否你的意思?
select * from (select * from table_name where itemid=3 order by inputdate desc) where rownum<3 union select * from (select * from table_name where itemid=5 order by inputdate desc) where rownum<3将表名table_name替换了在用,可能中间有敲错的,自己纠错吧
还是不行beckhambobo(beckham) 不过我已经解决了,谢谢你 ORA-00933: SQL command not properly ended
union all
select * from (select * from where INPUTDATE<(select INPUTDATE from table where itemid=5) order by INPUTDATE desc) a where rownum<=2
报错信息ORA-00903: invalid table name光标指向第二个*后面的from上
union all
select * from (select * from table where INPUTDATE<(select INPUTDATE from table where itemid=5) order by INPUTDATE desc) a where rownum<=2把相应的表名替换
报ORA-01427: single-row subquery returns more than one row
union
select * from (select * from table_name where itemid=5 order by inputdate desc) where rownum<3将表名table_name替换了在用,可能中间有敲错的,自己纠错吧
与 select INPUTDATE from table where itemid=5在表内已超过一条记录,当然报错select ITEMID,CONTENT,CHINESE from table group by ITEMID,CONTENT,CHINESE hvaing count(itemid)<=2 order by INPUTDATE desc;请楼主测试!
与 select INPUTDATE from table where itemid=5在表内已超过一条记录,当然报错select ITEMID,CONTENT,CHINESE from table group by ITEMID,CONTENT,CHINESE hvaing count(itemid)<=2 order by INPUTDATE desc;不知是否你的意思?
union
select * from (select * from table_name where itemid=5 order by inputdate desc) where rownum<3将表名table_name替换了在用,可能中间有敲错的,自己纠错吧
ORA-00933: SQL command not properly ended