SQLzoo: return a sequential record count for all records returned

return a sequential record count for all records returned

PostgreSQL

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, ...

Specific to PostgreSQL

none

SQLite
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, ...
Specific to SQLite
none

DB2
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, ...
Specific to DB2
none

MS Access
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, ...
Specific to MS Access
none

Oracle
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, ...	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);
Specific to Oracle
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.

MS SQL Server
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, ...
Specific to MS SQL Server
none

MySQL
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, ...	DROP TABLE numbered_cia; CREATE TABLE numbered_cia (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_cia (name, region, area, population,gdp) SELECT name, region, area, population, gdp FROM gisq.cia; SELECT * FROM numbered_cia
Specific to MySQL
This should be simple - but it isn't. Here is a nasty work around... Copy the required table into another with auto-increment:

Sybase
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, ...
Specific to Sybase
none

Mimer SQL
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, ...
Specific to Mimer SQL
none

Eine Einführung in SQL

return a sequential record count for all records returned

Eine Einführung in

SQL