Hello from Italy!


I have a table students with fields name and age

I need to do a select query like:

select name
from students

where I would like to add a field that is auto-increment, so the query
result must be:

id, name
1 mario
2 gino
3 saverio
4 ...

But I don't now how I can put a auto-increment field in a select
statement...

Can anyone me?

Thanks!