a SQL problem...

Dear experts,

I wonder whether I can add a serial no (from 1 to n) to the result of SQL listing.

e.g. Select name, age from person where sex='M';

then I get:

Name Age

John	20
Sam 	24
Ken	40

how can I do this:

No.	Name	Age
1	John	20
2	Sam	24
3	Ken 	40 

Thanks for your attention.

Ken

-- 

-------------------------------------------------------
All people have one thing in common, they are DIFFERENT
-------------------------------------------------------
Please visit my homepage (IQ Paradise)
http://home.netvigator.com/~leekawo 
My ICQ: 996903