Home » RDBMS Server » Server Administration » retrieving records
retrieving records [message #373891] Wed, 16 May 2001 09:26 Go to next message
ramana
Messages: 51
Registered: December 2000
Member
In a table there r 50 records.I want to retrive 4,5,6,7,8 records .how to do this?
please reply

Report message to a moderator

Re: retrieving records [message #373923 is a reply to message #373891] Thu, 17 May 2001 05:49 Go to previous message
Sirajdin
Messages: 17
Registered: May 2001
Junior Member
add a column..update it with rownum then use between in sql..no other way since direct between clause in rownum pseudo column won't work!

Report message to a moderator

Previous Topic: Importing .csv to Oracle table without sql loader
Next Topic: Max value
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Mon Dec 23 09:35:42 CST 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.