Hi,

> -----Urspr�ngliche Nachricht-----
> Von: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
> Gesendet: Dienstag, 18. M�rz 2003 12:53

> Your statement seems unnecessary complicated.

> How about
> 
> CREATE VIEW TEST (id, nr) as
> SELECT id, nr 
> FROM "M_RES".TEST 
> WHERE rownum BETWEEN 5 AND 10
> 

Here,
the next error

Column not found;-4005 POS(74) Unknown column name:ROWNUM.

I have installes SAPDB 7.4.3.14.
What is the alternative zu rownum?

Thanks,
Wolfgang
_______________________________________________
sapdb.general mailing list
[EMAIL PROTECTED]
http://listserv.sap.com/mailman/listinfo/sapdb.general

Reply via email to