> > 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
> ...

No, there isn't.

With regards,

Martijn Tonies
Database Workbench - developer tool for InterBase, Firebird, MySQL & MS SQL
Server
Upscene Productions
http://www.upscene.com