To find last entered row in sybase

• Ganapathi M

  Say Hey Kid

  Points: 707

  More actions

  September 4, 2007 at 12:28 am

  #118383

  Hello All,

  How can i find last entered row of a table. (No timestamp)

  E-x:

  Table name: student_dtl

  student class

  karthi   10

  Guna     7

  Ram      5

  Kavi      6

  Suresh  1 

   

  What is query to get 'Suresh  1'?

• Sergiy

  SSC Guru

  Points: 110208

  More actions

  September 4, 2007 at 4:01 am

  #731141

  There is no such thing as 1st or last row in relational databases.

  You need to store time of recording to know which record was the latest one.

  _____________
  Code for TallyGenerator

• Fracn

  Old Hand

  Points: 389

  More actions

  September 4, 2007 at 4:52 am

  #731150

  I think you may also add an id column in your table using the identity function.