how to select the newest entries ?

Replies

• 

  Morningdot Hablu

  No answer !!
• 

  Prasad Ajinkya

  in mysql, you have the LIMIT keyword, sort by the primary key in desc order and use LIMIT 10. that should do no?
• 

  Morningdot Hablu

  I have tried
  select * from table order by id desc limit 10;
  and
  select * from table order by id limit 10;
  both but it doesn't works !!
• 

  slashfear

  Hey Mohit,
  
  Can you specify what database your using because what kidakaka said is right !! in Mysql it will work!! if your using any other database for example in Microsoft SQLserver or SYBASE, LIMIT keyword is not supported so we have to use TOP keyword (mostly in databases it will either support TOP or LIMIT will be available) so this is how you can use your TOP keyword to accomplish the task what you asked for EG: select top 10 * from tablename order by id desc
  
  -Arvind