How to make row first row in table..

[Don E]

Hello everyone,

 

Just like this forum when a thread is updated and move to the top of threads made by someone posting in that particular thread and appears first in the list of threads made for that particular forum, how do we make a row become the first row for a particular table?

 

I hope my question is clear.

 

Thanks.

[justsomeguy]

You use ORDER BY. There's no reason to try and change how records are physically stored by the database server.

[Don E]

Would that be ORDER BY last insert/updated ID? Can you point me to an example? Thanks.

[Ingolme]

Here's the tutorial page for the ORDER BY keyword: http://www.w3schools.com/sql/sql_orderby.asp

 

Usually when you retrieve the data you would order by date in descending order.

[Don E]

Usually when you retrieve the data you would order by date in descending order.

 

Right, of course!