[Date Prev][Date Next][Thread Prev][Thread Next]
[Author Index] [Date Index] [Thread Index]
[SQR-USERS Info] [SQRUG Home Page]

Re: [sqr-users] Question about TOP and SQR

You can use the Loops = <Number> attribute of the Begin-Select statement.
Using the OrderBy, you can pick the row you are looking for.

Sudeep


 Does SQR allow the use of TOP, as in SELECT TOP 1 MAX(A.COLUMN) FROM
> DATABASE.TABLE?
>
>
>
> Thank you,
>
>
>
> Leanne Harrisburg
>
> National University
>
> Programmer/Analyst
>
> voice: (619) 563-2635
>
> Fax: (619) 563-7933
>
>
>
> _______________________________________________
> sqr-users mailing list
> sqr-users@sqrug.org
> http://www.sqrug.org/mailman/listinfo/sqr-users
>


_______________________________________________
sqr-users mailing list
sqr-users@sqrug.org
http://www.sqrug.org/mailman/listinfo/sqr-users