[covert215]

2 Questions:

1. How do I calculate the number of rows in a table? I want to be able to retrieve the last row in the table.

2. When inserting rows, is the new row added to the end of the table?

Thanks

[covert215]

Its been more than 24 hrs.......

[brendandonhu]

SELECT COUNT(*) FROM table

And if you want the rows in a specific order, you can use an ORDER BY clause in your query.