Sybase NNTP forums - End Of Life (EOL)

The NNTP forums from Sybase - forums.sybase.com - are now closed.

All new questions should be directed to the appropriate forum at the SAP Community Network (SCN).

Individual products have links to the respective forums on SCN, or you can go to SCN and search for your product in the search box (upper right corner) to find your specific developer center.

Window Functions - SQL 2003 standard

2 posts in General Discussion Last posting was on 2011-11-14 11:00:35.0Z
Alberto Posted on 2011-11-14 10:42:37.0Z
Sender: 7052.4ec0e912.1804289383@sybase.com
From: Alberto
Newsgroups: sybase.public.ase.general
Subject: Window Functions - SQL 2003 standard
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <4ec0f09c.718d.1681692777@sybase.com>
NNTP-Posting-Host: 10.22.241.41
X-Original-NNTP-Posting-Host: 10.22.241.41
Date: 14 Nov 2011 02:42:37 -0800
X-Trace: forums-1-dub 1321267357 10.22.241.41 (14 Nov 2011 02:42:37 -0800)
X-Original-Trace: 14 Nov 2011 02:42:37 -0800, 10.22.241.41
Lines: 6
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.ase.general:30682
Article PK: 73574

I see that ASA & IQ support "Window Functions" from the SQL
2003 standard:
OVER/PARTITION BY, LAG, LEAD, RANK, ROW_NUMBER, etc.

Does ASE 15.7 support these window functions?
Will it support window functions?


Rob V Posted on 2011-11-14 11:00:35.0Z
From: Rob V <rob@DO.NOT.SPAM.sypron.nl.REMOVE.THIS.DECOY>
Reply-To: rob@DO.NOT.SPAM.sypron.nl.REMOVE.THIS.DECOY
Organization: Sypron BV
User-Agent: Mozilla/5.0 (Windows NT 5.1; rv:8.0) Gecko/20111105 Thunderbird/8.0
MIME-Version: 1.0
Newsgroups: sybase.public.ase.general
Subject: Re: Window Functions - SQL 2003 standard
References: <4ec0f09c.718d.1681692777@sybase.com>
In-Reply-To: <4ec0f09c.718d.1681692777@sybase.com>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <4ec0f4d3$1@forums-1-dub>
Date: 14 Nov 2011 03:00:35 -0800
X-Trace: forums-1-dub 1321268435 10.22.241.152 (14 Nov 2011 03:00:35 -0800)
X-Original-Trace: 14 Nov 2011 03:00:35 -0800, vip152.sybase.com
Lines: 30
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.ase.general:30683
Article PK: 73573


On 14-Nov-2011 11:42, Alberto wrote:
> I see that ASA& IQ support "Window Functions" from the SQL
> 2003 standard:
> OVER/PARTITION BY, LAG, LEAD, RANK, ROW_NUMBER, etc.
>
> Does ASE 15.7 support these window functions?
> Will it support window functions?

ASE 15.7 does not currently support these functions.

--
HTH,

Rob V.
-----------------------------------------------------------------
Rob Verschoor

Certified Sybase Professional DBA for ASE 15.0/12.5/12.0/11.5/11.0
and Replication Server 15.0.1/12.5 // TeamSybase

Author of Sybase books (order online at www.sypron.nl/shop):
"Tips, Tricks& Recipes for Sybase ASE"
"The Complete Sybase IQ Quick Reference Guide"
"The Complete Sybase ASE Quick Reference Guide"
"The Complete Sybase Replication Server Quick Reference Guide"

rob@NO.SPAM.sypron.nl | www.sypron.nl | Twitter: @rob_verschoor
Sypron B.V., The Netherlands | Chamber of Commerce 27138666
-----------------------------------------------------------------