How to do?

Hi,

Have question....

How to do such like this:

I have: select <column list> form <tables> where <where statement>;
how to make one column be row numbers in result?

and second one:
have select like above.... and I know that in result is record with e.g.
uid='AC13A1'.
How to reduce result to this record and one record before in result and one
record after in result?

Are this questions just silly problems? :-)

regards