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.

DENSE_RANK() in ASE

5 posts in Product Futures Discussion Last posting was on 2010-07-23 11:09:40.0Z
anuj-z.kumar Posted on 2009-09-21 13:16:29.0Z
Sender: 11b5.4ab77c2a.1804289383@sybase.com
From: anuj-z.kumar@ubs.com
Newsgroups: sybase.public.ase.product_futures_discussion
Subject: DENSE_RANK() in ASE
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <4ab77cad.11cf.1681692777@sybase.com>
NNTP-Posting-Host: 10.22.241.41
X-Original-NNTP-Posting-Host: 10.22.241.41
Date: 21 Sep 2009 06:16:29 -0700
X-Trace: forums-1-dub 1253538989 10.22.241.41 (21 Sep 2009 06:16:29 -0700)
X-Original-Trace: 21 Sep 2009 06:16:29 -0700, 10.22.241.41
Lines: 2
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.ase.product_futures_discussion:2042
Article PK: 97642

Is there any function in Sybase ASE 12.5.3 similar to Oracle
DENSE_RANK()?


Carl Kayser Posted on 2009-09-21 13:30:25.0Z
From: "Carl Kayser" <kayser_c@bls.gov>
Newsgroups: sybase.public.ase.product_futures_discussion
References: <4ab77cad.11cf.1681692777@sybase.com>
Subject: Re: DENSE_RANK() in ASE
Lines: 9
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.3598
X-RFC2646: Format=Flowed; Original
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.3350
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <4ab77ff1$1@forums-1-dub>
Date: 21 Sep 2009 06:30:25 -0700
X-Trace: forums-1-dub 1253539825 10.22.241.152 (21 Sep 2009 06:30:25 -0700)
X-Original-Trace: 21 Sep 2009 06:30:25 -0700, vip152.sybase.com
X-Authenticated-User: ase1251
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.ase.product_futures_discussion:2043
Article PK: 97641


<anuj-z.kumar@ubs.com> wrote in message
news:4ab77cad.11cf.1681692777@sybase.com...
> Is there any function in Sybase ASE 12.5.3 similar to Oracle
> DENSE_RANK()?

What does DENSE_RANK () provide?


Glenn Paulley [Sybase iAnywhere] Posted on 2009-09-21 13:33:44.0Z
From: "Glenn Paulley [Sybase iAnywhere]" <paulley@ianywhere.com>
Reply-To: paulley@ianywhere.com
Organization: Sybase iAnywhere
User-Agent: Thunderbird 2.0.0.23 (Windows/20090812)
MIME-Version: 1.0
Newsgroups: sybase.public.ase.product_futures_discussion
Subject: Re: DENSE_RANK() in ASE
References: <4ab77cad.11cf.1681692777@sybase.com> <4ab77ff1$1@forums-1-dub>
In-Reply-To: <4ab77ff1$1@forums-1-dub>
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: <4ab780b8$1@forums-1-dub>
Date: 21 Sep 2009 06:33:44 -0700
X-Trace: forums-1-dub 1253540024 10.22.241.152 (21 Sep 2009 06:33:44 -0700)
X-Original-Trace: 21 Sep 2009 06:33:44 -0700, vip152.sybase.com
Lines: 34
X-Authenticated-User: techsupp
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.ase.product_futures_discussion:2044
Article PK: 97644

See

http://www.sybase.com/detail?id=1037447

Glenn

Carl Kayser wrote:
> <anuj-z.kumar@ubs.com> wrote in message
> news:4ab77cad.11cf.1681692777@sybase.com...
>> Is there any function in Sybase ASE 12.5.3 similar to Oracle
>> DENSE_RANK()?
>
> What does DENSE_RANK () provide?
>
>

--
Glenn Paulley
Director, Engineering (Query Processing)
Sybase iAnywhere

Blog: http://iablog.sybase.com/paulley

EBF's and Patches: http://downloads.sybase.com
choose SQL Anywhere Studio >> change 'time frame' to all

To Submit Bug Reports: http://case-express.sybase.com

SQL Anywhere Studio Supported Platforms and Support Status
http://my.sybase.com/detail?id=1002288

Whitepapers, TechDocs, and bug fixes are all available through the
Sybase iAnywhere pages at
http://www.sybase.com/products/databasemanagement/sqlanywhere/technicalsupport