How do I get just the Nth row of data from sybase?

Question

I have a table with multiple rows for each user. Each user will have the same number of rows but the row ids are all different for each user, so how I do get just the Nth row for a given user?

Assuming an order by user_id, row_id clause so you can be guaranteed a consistent order for any given user.

This is sybase 12 I'm working with here.

Answer 1

if you can add seq_id column to that table that started from 0 for each user_id. You can query with this column.