[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
- Subject: Re: [sqr-users] Question about TOP and SQR
- From: "the dragon" <ceprn@hotmail.com>
- Date: Wed, 21 Sep 2005 14:55:15 -0500
- Bcc:
- Delivery-date: Wed, 21 Sep 2005 14:56:18 -0500
- In-reply-to: <29223.208.250.32.6.1127326836.squirrel@192.168.175.202>
- List-id: "This list is for discussion about the SQR database reportinglanguage from Hyperion Solutions." <sqr-users.sqrug.org>
If I remeber correctly, loops = only works with certain platforms; more
specifically, I have had certain platforms that refused to work with it.
Give it a try and see what happens.
peace,
clark 'the dragon' willis
PSA: Salary <> Slavery. If you earn a salary, your employer is renting your
services for 40 hours a week, not purchasing your soul. Your time is the
only real finite asset that you have, and once used it can never be
recovered, so don't waste it by giving it away.
I work to live; I don't live to work.
"Time is the coin of your life. It is the only coin you have, and only you
can determine how it will be spent. Be careful lest you let other people
spend it for you."
Carl Sandburg
(1878 - 1967)
----Original Message Follows----
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