Basically I am looking for the equivalent of rownum in Oracle. I have a scenario where I have to get the first row in the selected set. I have found that fetch first n rows only does the same for me.
But this does not seem to work from inside a SQL stored procedure. Whenever I give this clause with the select statement inside a SQL stored procedure . It says unexpected token. What should I use ? Can anyone help. Thanks Ranjana ===== To unsubscribe, send 'unsubscribe' to [EMAIL PROTECTED] For other info (and scripts), see http://people.mn.mediaone.net/scottrmcleod
