autonumber rows in SQL result, how to

2004-04-01 Thread Miroslav I.
- how to autonumber rows in SQL result I would like to put an auto numbering column in any SQL SELECT result, is it possibile? miroslav i.

how to 'tell' the select what to omit

2003-08-04 Thread Miroslav I.
Hallo suppose you have a table with great number of columns (20 or 30), and you would like to specify every one but two or tree columns in a SELECT statement. Is there a way to specify only those two or tree columns for omission (which would be the 'short' way to do the job) instead of specifyin

auto number primary key - restarting

2003-07-15 Thread Miroslav I.
Hi, is there an SQL command for making a primary key (auto number key) to start numbering from beginning after deleting all the records from the table. thanks