CODEWITHSUNDEEP
sap-ase
BuZz
BuZz

Reputation: 17495

In sybase 12.5, can I have some SQL to get the Nth to Mth row?

In sybase 12.5 (ASE, not Sql Anywhere), can I use some (ANSI) SQL to get the Nth to Mth row ?

Otherwise, a pointer to a non-ANSI way will help, I can't find it !

Upvotes: 1

Views: 556

Answers (1)

aF.
aF.

Reputation: 66757

One possible solution:

select rownum=identity(10), t.* into #temp from tablename t

select * from #temp where rownum between 5 and 10

drop table #temp

Replace 5 and 10 by the Nth and Mth values.

Upvotes: 1

Related Questions