Re: Sybase - Selecting specific numbers of records

[Carlton Conley <cconley@CDG-INC.COM>]

Not knowing why you want only 20 rows makes it somewhat difficult, are there
10 rows specically you want or just any ten rows.

if the later you so something like:


if #count <= 10
        do someprocedure
end-if

begin-procedure someprocedure
begin-select

SOMECOLUMN(S)

        add 1 to #count

FROM SOMETABLE

end-select
end-procedure

> -----Original Message-----
> From: Discussion of SQR, SQRIBE Technologies's database reporting
> language [mailto:SQR-USERS@list.iex.net]On Behalf Of Khaled Abdel-Rahman
> Sent: Tuesday, October 26, 1999 11:22 AM
> To: Multiple recipients of list SQR-USERS
> Subject: Sybase - Selecting specific numbers of records
>
>
> Hi,
>      This is my first question to the list an the following is my first
> question!!!!!
>
>      Suppose you have a table which has 20 rows, I want to get only rows
> from 10-15. How can I don that?!
>
>      Thanks in advance,
>      Best Regards,
>      Khaled
>