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?
__._,_.___
Posted by: "=?gb18030?B?aHoueWI=?=" <hz.yb@foxmail.com>
| Reply via web post | • | Reply to sender | • | Reply to group | • | Start a New Topic | • | Messages in this topic (1) |
Save time and get your email on the go with the Yahoo Mail app
Get the beautifully designed, lighting fast, and easy-to-use Yahoo Mail today. Now you can access all your inboxes (Gmail, Outlook, AOL and more) in one place. Never delete an email again with 1000GB of free cloud storage.
++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
Visit http://www.firebirdsql.org and click the Documentation item
on the main (top) menu. Try FAQ and other links from the left-side menu there.
Also search the knowledgebases at http://www.ibphoenix.com/resources/documents/
++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
Visit http://www.firebirdsql.org and click the Documentation item
on the main (top) menu. Try FAQ and other links from the left-side menu there.
Also search the knowledgebases at http://www.ibphoenix.com/resources/documents/
++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
.
__,_._,___
No comments:
Post a Comment