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?

Reply via email to