Path: news.easynews.com!easynews!newsfeed.frii.net!news-spur1.maxwell.syr.edu!news.maxwell.syr.edu!newsfeed.icl.net!opentransit.net!wanadoo.fr!not-for-mail From: "Samuel Tribehou" Newsgroups: comp.databases.theory Subject: auto increment in select clause Date: Thu, 6 Jun 2002 23:00:13 +0200 Organization: Wanadoo, l'internet avec France Telecom Lines: 18 Message-ID: NNTP-Posting-Host: acaen-103-1-2-181.abo.wanadoo.fr X-Trace: wanadoo.fr 1023397210 13563 80.14.18.181 (6 Jun 2002 21:00:10 GMT) X-Complaints-To: abuse@wanadoo.fr NNTP-Posting-Date: 6 Jun 2002 21:00:10 GMT X-Priority: 3 X-MSMail-Priority: Normal X-Newsreader: Microsoft Outlook Express 6.00.2600.0000 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2600.0000 Xref: easynews comp.databases.theory:21121 X-Received-Date: Thu, 06 Jun 2002 13:57:35 MST (news.easynews.com) Hello. I'd like to know how if it is possible to have an auto incremented column in a select clause, like this : inc | ref 1 | AAE 2 | ADE 3 | A3D where the inc column is generated on the fly. Thanks in advance.