Home » Infrastructure » Windows » commnad ora
commnad ora [message #101481] Wed, 27 October 2004 03:42 Go to next message
sanukaji
Messages: 1
Registered: October 2004
Junior Member
sir

how i can apply the rowno and greater than command in sql prompt like

select * from abc where rowno>=5;

thank u for yr kind co-opration.

 

sanju

nepal

Report message to a moderator

Re: commnad ora [message #101511 is a reply to message #101481] Fri, 12 November 2004 07:37 Go to previous message
Frank Naude
Messages: 4581
Registered: April 1998
Senior Member
Try this: 

select * 
  from (select rownum as rowno, abc.* from abc) x 
 where rowno >= 5 
/


Best regards.

Frank

Report message to a moderator

Previous Topic: ORA-00439: feature not enabled: Partitioning
Next Topic: Oracle installation problem
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Mon Nov 25 14:04:06 CST 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.