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.

Row Number

3 posts in General Discussion Last posting was on 2005-05-05 14:20:16.0Z
Michael Posted on 2005-05-04 15:02:02.0Z
Sender: 302c.42781fcb.1804289383@sybase.com
From: Michael
Newsgroups: ianywhere.public.general
Subject: Row Number
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <4278e3e6.367e.1681692777@sybase.com>
X-Original-NNTP-Posting-Host: 10.22.241.42
X-Original-Trace: 4 May 2005 08:01:58 -0700, 10.22.241.42
Lines: 11
X-Original-NNTP-Posting-Host: forums-2-dub.sybase.com
X-Original-Trace: 4 May 2005 08:01:59 -0700, forums-2-dub.sybase.com
NNTP-Posting-Host: forums-master.sybase.com
X-Original-NNTP-Posting-Host: forums-master.sybase.com
Date: 4 May 2005 08:02:02 -0700
X-Trace: forums-1-dub 1115218922 10.22.108.75 (4 May 2005 08:02:02 -0700)
X-Original-Trace: 4 May 2005 08:02:02 -0700, forums-master.sybase.com
X-Authenticated-User: ngsysop
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:4444
Article PK: 8253

Hi, I need to know does ASA 8.0.3 has row number function ?
I expect when run quer : select rownumber(), name from
employee, ASA returns :
RowNumber Name
======== ====
1 Alice
2 Audrey
3 Brad

If ASA doesn't have it, does anyone here have an idea how to
make it?


Reg Domaratzki (iAnywhere Solutions) Posted on 2005-05-04 17:57:36.0Z
From: "Reg Domaratzki \(iAnywhere Solutions\)" <Spam_bad_rdomarat@ianywhere.com>
Newsgroups: ianywhere.public.general
References: <4278e3e6.367e.1681692777@sybase.com>
Subject: Re: Row Number
Lines: 27
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2800.1437
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1441
X-Original-NNTP-Posting-Host: rdomarat-pc.sybase.com
Message-ID: <42790d0c$1@forums-2-dub>
X-Original-Trace: 4 May 2005 10:57:32 -0700, rdomarat-pc.sybase.com
X-Original-NNTP-Posting-Host: forums-2-dub.sybase.com
X-Original-Trace: 4 May 2005 10:57:33 -0700, forums-2-dub.sybase.com
NNTP-Posting-Host: forums-master.sybase.com
X-Original-NNTP-Posting-Host: forums-master.sybase.com
Date: 4 May 2005 10:57:36 -0700
X-Trace: forums-1-dub 1115229456 10.22.108.75 (4 May 2005 10:57:36 -0700)
X-Original-Trace: 4 May 2005 10:57:36 -0700, forums-master.sybase.com
X-Authenticated-User: ngsysop
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:4446
Article PK: 8255

select number(*),name from employee

--
Reg Domaratzki, Sybase iAnywhere Solutions
Sybase Certified Professional - Sybase ASA Developer Version 8
Please reply only to the newsgroup

iAnywhere Developer Community : http://www.ianywhere.com/developer
iAnywhere Documentation : http://www.ianywhere.com/developer/product_manuals
ASA Patches and EBFs : http://downloads.sybase.com/swx/sdmain.stm
-> Choose SQL Anywhere Studio
-> Set "Platform Preview" and "Time Frame" to ALL

<Michael> wrote in message news:4278e3e6.367e.1681692777@sybase.com...
> Hi, I need to know does ASA 8.0.3 has row number function ?
> I expect when run quer : select rownumber(), name from
> employee, ASA returns :
> RowNumber Name
> ======== ====
> 1 Alice
> 2 Audrey
> 3 Brad
>
> If ASA doesn't have it, does anyone here have an idea how to
> make it?


Glenn Paulley Posted on 2005-05-05 14:20:16.0Z
Newsgroups: ianywhere.public.general
Subject: Re: Row Number
From: Glenn Paulley <paulley@ianywhere.com>
References: <4278e3e6.367e.1681692777@sybase.com>
Organization: iAnywhere Solutions
Message-ID: <Xns964D6929DDE6Fpaulleyianywherecom@10.22.241.106>
User-Agent: Xnews/5.04.25
NNTP-Posting-Host: 10.25.99.149
X-Original-NNTP-Posting-Host: 10.25.99.149
Date: 5 May 2005 07:20:16 -0700
X-Trace: forums-1-dub 1115302816 10.25.99.149 (5 May 2005 07:20:16 -0700)
X-Original-Trace: 5 May 2005 07:20:16 -0700, 10.25.99.149
Lines: 29
X-Authenticated-User: techsupp
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:4449
Article PK: 8259


Michael wrote in news:4278e3e6.367e.1681692777@sybase.com:

> Hi, I need to know does ASA 8.0.3 has row number function ?
> I expect when run quer : select rownumber(), name from
> employee, ASA returns :
> RowNumber Name
> ======== ====
> 1 Alice
> 2 Audrey
> 3 Brad
>
> If ASA doesn't have it, does anyone here have an idea how to
> make it?

Reg has given you NUMBER(*) as an alternative that will give you the same
semantics in 8.0.3. The ROW_NUMBER function is available in 9.0.1.

--
Glenn Paulley
Research and Development Manager, Query Processing
iAnywhere Solutions Engineering

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

To Submit Bug Reports: http://casexpress.sybase.com/cx/cx.stm

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