Return a sequential record count for all records returned - Revision history

Connor at 12:43, 17 July 2012

2012-07-17T12:43:50Z

Connor at 12:43, 17 July 2012

2012-07-17T12:43:31Z

Connor: Created page with "Return a sequential record count for all records returned

schema:gisq

this should be simple - I would like to get a consecutive ..."

2012-07-17T12:42:54Z

Created page with "Return a sequential record count for all records returned <div class='ht'> <div class=params>schema:gisq</div> <div> this should be simple - I would like to get a consecutive ..."

New page

Return a sequential record count for all records returned
<div class='ht'>
<div class=params>schema:gisq</div>
<div>
this should be simple - I would like to get a consecutive numbering count/id for each record returned from a query: eg: select * from tablex gives multiple rows like:

field1, field2, field3, ...
field1, field2, field3, ...
field1, field2, field3, ...

What I want is:

1, field1, field2, field3, ...
2, field1, field2, field3, ...
3, field1, field2, field3, ...
4, field1, field2, field3, ...
</div>
<source lang=sql class='tidy'>
</source>
<source lang='sql' class='def e-oracle'>select rownum, field1, field2, field3
from table_name;
select rownum, field1, field2, field3
from (select field1, field2, field3
from table_name
order by field1, field2, field3);
</source>
<source lang='sql' class='def e-mysql'>DROP TABLE numbered_bc;
CREATE TABLE numbered_bbc
(counter INTEGER NOT NULL AUTO_INCREMENT PRIMARY KEY
,name VARCHAR(50)
,region VARCHAR(60)
,area DECIMAL(10,0)
,population DECIMAL(11,0)
,gdp DECIMAL(14,0)
);
INSERT INTO numbered_bbc (name, region, area,
population,gdp)
SELECT name, region, area, population, gdp
FROM gisq.bbc;
SELECT * FROM numbered_bbc
</source>
<source lang='sql' class='def'>
</source>
<div class="ecomm e-oracle" style="display: none">Use the psuedo-column ROWNUM. Note that ROWNUM is evaluation prior to the ORDER BY clause. To apply ROWNUM to an ordered result, use an inline view.</div>
<div class="ecomm e-mysql" style="display: none">This should be simple - but it isn't. Here is a nasty work around...
Copy the required table into another with auto-increment:</div>
</div>
{{Meta Data ref}}

@@ Line 1: / Line 1: @@
 Return a sequential record count for all records returned
 <div class='ht'>
-<div class=params>schema:gisq</div>
+<div class=params>schema:scott</div>
 <div>
 this should be simple - I would like to get a consecutive numbering count/id for each record returned from a query: eg: select * from tablex gives multiple rows like:

@@ Line 25: / Line 25: @@
           order by field1, field2, field3);
 </source>
-<source lang='sql' class='def e-mysql'>DROP TABLE numbered_bc;
+<source lang='sql' class='def e-mysql'>DROP TABLE numbered_bbc;
 CREATE TABLE numbered_bbc
    (counter INTEGER NOT NULL AUTO_INCREMENT PRIMARY KEY

Return a sequential record count for all records returned - Revision history

Connor at 12:43, 17 July 2012

Connor at 12:43, 17 July 2012

Connor: Created page with "Return a sequential record count for all records returned schema:gisq this should be simple - I would like to get a consecutive ..."

Connor: Created page with "Return a sequential record count for all records returned

schema:gisq

this should be simple - I would like to get a consecutive ..."