How to slice the result set by row number in SQL 7.0

[henryz]

Hi,

Is it possible to slice the result set by row number in SQL 7.0 ? I know in
Oracle, there is a keyword called "ROWNUM" which can easily slice the result
by specifying a fixed number of returned rows. How can we do this in SQL
7.0?

Thanks

Henry

 

[tomschafer]

Use the the global variable @@rowcount

 

[vishnuprasad]

If i have understood this, then i think it is possible by a datatype "Uniqueidentifier" which provides u with a globally unique GUID for each row in the DB. Further I dont know how "@@Rowcount" is going to help this.Further u can use "Fetch relative" statement with cursor which might work but is too complicated.

Hope this was of some help.