[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: "Steve Cavill" <steve.cavill@infoclarity.com.au>
- Date: Mon, 10 Oct 2005 11:50:16 +1000
- Delivery-date: Sun, 09 Oct 2005 20:51:25 -0500
- In-reply-to: <889569168659C444BE9E5940193C06C168E519@DELLFDGDK11.nu.edu>
- List-id: "This list is for discussion about the SQR database reportinglanguage from Hyperion Solutions." <sqr-users.sqrug.org>
- Thread-index: AcW+1mnFtfnkCkhrQByFUEapSmzwMgOZnA4g
I just tried this and it worked fine (Microsoft sql server)
Begin-Program
Position (1,1)
Do Master_Query
End-Program
Begin-Procedure Master_Query
begin-select
top 10 sal (1,1)
next-Listing
from emp
end-select
end-procedure
Steve.
-----Original Message-----
From: sqr-users-bounces+steve.cavill=infoclarity.com.au@sqrug.org
[mailto:sqr-users-bounces+steve.cavill=infoclarity.com.au@sqrug.org] On Behalf
Of Leanne Harrisburg
Sent: Thursday, 22 September 2005 4:01 AM
To: sqr-users@sqrug.org
Subject: [sqr-users] Question about TOP and SQR
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