i want to get rownum?how to select?thanks
table: CREATE TABLE PZ ( ID INTEGER NOT NULL, RQ TIMESTAMP NOT NULL, JE DECIMAL(18,2), /* Keys */ PRIMARY KEY (ID) ); data: INSERT INTO PZ (ID, RQ, JE) VALUES (11, '2016-01-01 23:55:00', 84.38); INSERT INTO PZ (ID, RQ, JE) VALUES (12, '2016-01-02 23:55:00', 37.97); i want to get rownum(ORDER BY RQ),for example: ROWNUM ID RQ JE 1 11 2016-01-01 23:55:00 84.38 2 12 2016-01-02 23:55:00 37.97 HOW TO SELECT?
