how to find the previous record of the table

• • Reply

  14 years ago

  by sundarraj

  raj

  , India

  Joined 14 years ago

  In a table i have to find the previous(only one) record of an employee

  i have 200 records in my table .but i know 150th record details.i would like to find the 149th record

  details.

  Report abuse
• • Reply

  14 years ago

  by lexian

  Alexis Méndez

  , Puerto Rico

  Joined 14 years ago

  Could you explain more of what you want? Could you place a littler example? And the table schema.

  Report abuse
• • Reply

  14 years ago

  by khari6579

  Hari K

  Chennai, India

  Joined 15 years ago
  Hi Sundaraj
   Try the follwoing method.
  
   select * from (select * from t1 order by x )  where rownum =149;
  
  
  I hope this method will solve ur problem
  
  Good LUck
  
  
  Regards
  Hari K......
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  Report abuse