Subject Re: [firebird-support] ROWNUM
Author Helen Borrie
At 10:00 AM 17/01/2005 +0000, you wrote:


>Is there any SQL command that have similiarly function like
>ROWNUM?, example:
>
>"SELECT ROWNUM as ORDER, TITLE FROM BOOK ORDER BY ROWNUM"

SELECT ROWNUM as ORDER, TITLE FROM BOOK ORDER BY 1

./hb