Continuous numbering from SELECT 
Author Message
 Continuous numbering from SELECT

This message is in MIME format. Since your mail reader does not understand
this format, some or all of this message may not be legible.

------_=_NextPart_001_01C05870.6C9C1A48
Content-Type: text/plain;
        charset="iso-8859-2"

Hello,

is there any way of continuous numbering of output rows from any SELECT
statement ?

Thanks  Pepa

------_=_NextPart_001_01C05870.6C9C1A48
Content-Type: text/html;
        charset="iso-8859-2"
Content-Transfer-Encoding: quoted-printable

<html xmlns:o=3D"urn:schemas-microsoft-com:office:office" =
xmlns:w=3D"urn:schemas-microsoft-com:office:word" =
xmlns=3D" http://www.***.com/ ;>

<head>
<META HTTP-EQUIV=3D"Content-Type" CONTENT=3D"text/html; =
charset=3Diso-8859-2">

<meta name=3DProgId content=3DWord.Document>
<meta name=3DGenerator content=3D"Microsoft Word 9">
<meta name=3DOriginator content=3D"Microsoft Word 9">

<!--[if gte mso 9]><xml>
 <o:OfficeDocumentSettings>
  <o:DoNotRelyOnCSS/>
 </o:OfficeDocumentSettings>
</xml><![endif]--><!--[if gte mso 9]><xml>
 <w:WordDocument>
  <w:View>Normal</w:View>
  <w:Zoom>0</w:Zoom>
  <w:DocumentKind>DocumentEmail</w:DocumentKind>
  <w:HyphenationZone>21</w:HyphenationZone>
  <w:EnvelopeVis/>
  <w:DoNotOptimizeForBrowser/>
 </w:WordDocument>
</xml><![endif]-->
<style>
<!--
 /* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
        {mso-style-parent:"";
        margin:0cm;
        margin-bottom:.0001pt;
        mso-pagination:widow-orphan;
        font-size:12.0pt;
        font-family:"Times New Roman";
        mso-fareast-font-family:"Times New Roman";}
p.MsoAutoSig, li.MsoAutoSig, div.MsoAutoSig
        {margin:0cm;
        margin-bottom:.0001pt;
        mso-pagination:widow-orphan;
        font-size:12.0pt;
        font-family:"Times New Roman";
        mso-fareast-font-family:"Times New Roman";}
span.StylZprvyElektronickPoty15
        {mso-style-type:personal-compose;
        mso-ansi-font-size:10.0pt;
        mso-ascii-font-family:Arial;
        mso-hansi-font-family:Arial;
        mso-bidi-font-family:Arial;

        {size:595.3pt 841.9pt;
        margin:70.85pt 70.85pt 70.85pt 70.85pt;
        mso-header-margin:35.4pt;
        mso-footer-margin:35.4pt;
        mso-paper-source:0;}
div.Section1
        {page:Section1;}
-->
</style>
</head>

<body lang=3DCS style=3D'tab-interval:35.4pt'>

<div class=3DSection1>

<p class=3DMsoNormal><font size=3D3 color=3Dblack face=3D"Times New =
Roman"><span
style=3D'font-size:12.0pt;color:black'>Hello,<br>
<br>
is there any way of continuous numbering of output rows from any =
SELECT<br>
statement ?<br>
<br>
Thanks&nbsp; Pepa<br style=3D'mso-special-character:line-break'>
<![if !supportLineBreakNewLine]><br =
style=3D'mso-special-character:line-break'>
<![endif]></span></font><span class=3DStylZprvyElektronickPoty15><font =
size=3D2
color=3Dblack face=3DArial><span =
style=3D'font-size:10.0pt;mso-bidi-font-size:12.0pt;
font-family:Arial'><o:p></o:p></span></font></span></p>

</div>

</body>

</html>

------_=_NextPart_001_01C05870.6C9C1A48--



Wed, 18 Jun 1902 08:00:00 GMT
 Continuous numbering from SELECT

Quote:

> This message is in MIME format.

Please do not post MIME format messages.

Quote:
> is there any way of continuous numbering of output rows from any SELECT
> statement ?

As in the ROWNUM feature of Oracle?  No, not straight-forwardly.  It can
be done with a UDR in Foundation 2000, but that's about it.

--
Yours,

Guardian of DBD::Informix v1.00.PC1 -- http://www.perl.com/CPAN
     "I don't suffer from insanity; I enjoy every minute of it!"



Wed, 18 Jun 1902 08:00:00 GMT
 
 [ 2 post ] 

 Relevant Pages 

1. Randomly selecting 5 continuous numbers HELP

2. How to delete a continuous number of data in a table

3. SQL: number of continuous periods with or without orders

4. select the top number records where the qty would sum to a given number

5. How can I limit the number of records selected with SELECT - SQL in FPW

6. NUMBER(9) UNION NUMBER(9) results in NUMBER(32,32)

7. Select from unknown number of databases

8. SELECT DISTINCT [high number of columns] fails

9. Selecting a row by it's row number

10. select or update by column number

11. Fetching the number of rows returned by a SELECT statement

12. SELECT number of rows


 
Powered by phpBB® Forum Software