I'm trying out a SQL statement syntax which works in my friend's system but failed at my system..
wonder why...
syntax
select * from
( select a.*, rownum as rnum from
( select * from table1
order by pcno ) a
where rownum < = 5)
where rnum >= 1
anyone knows why am i getting the Error :
ORA-00907: missing right parenthesis
wonder why...
syntax
select * from
( select a.*, rownum as rnum from
( select * from table1
order by pcno ) a
where rownum < = 5)
where rnum >= 1
anyone knows why am i getting the Error :
ORA-00907: missing right parenthesis