Originally posted by sudhakalluri
i have a table with 40000 records..
if i want to get only the rows from 20000-40000..the last half of the records..
how can i get?
There is no specific rowid concept in sybase. In sybase we can have identity column which is equavalent to rowid in oracle but not useful in sql queries. For you requirement you can have condition which satisfies your requirement , otherwise use bcp command with F,L options.