Geek asks and answers

ROWNumber in Sqlite

In SQL Server2005, the Row_number () function is used to retrieve the sequence number of a row within a section of a result set, starting at 1 for the first row in each section. This is very useful when paging through a large number of records in a table. Here, any feature available in SQLite is like this.

+5
source share
2 answers

No. You will usually process this data using your own code.

0
source

You can simulate zero numbering done using the ROW_NUMBER () function with a code similar to the format below.

CREATE TABLE Temp.Output AS
SELECT *
FROM  (
    SELECT 10 AS ID,'Darren' AS Name
    UNION ALL
    SELECT 20,'Roger'
    UNION ALL
    SELECT 30,'Emil'
    UNION ALL
    SELECT 40,'Doug'
    UNION ALL
    SELECT 50,'Martin'
)
ORDER BY Name ASC
;
SELECT ROWID AS ROWNUMBER, ID, Name
FROM Temp.Output
;
DROP TABLE Temp.Output
;

"PARTITION BY" ( SQL, , , ).

0

More articles:


All Articles