--- In firebird-support@yahoogroups.com, "esrefatak" <liste@y...> wrote:

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

example:

create table book (
id numeric(10,0),
title varchar (100),
author varchar (50)
);

SELECT ROWNUM as ORDER, TITLE
FROM BOOK
ORDER BY ROWNUM;

ORDER TITLE
----- -------------------------
1 Firebird and security
2 ColdFusion and security
3 Oracle and speed
...


---
best regards,
esrefatak