Member Avatar for mangel.murti

hi all,
how to display last 10 record form a table.please help me.

  • 3 Contributors
  • 2 Replies
  • 104 Views
  • 13 Hours Discussion Span
  • Latest Post Latest Post by dickersonka
Member Avatar for pritaeas

Do you have a timestamp column ? Then sort descending and limit 10 on that column.

Member Avatar for dickersonka

either go with a timestamp or id column, assuming its an integer or bigint

select * from table order by idcolumn desc limit 10

select * from table order by timestampcolumn desc limit 10
Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.