Karthik K

Karthik K

  • 1k
  • 743
  • 193.4k

How to Select Recent Top of the Query ?..In Oracke

Jul 19 2013 2:02 AM
Dear Friends ,



                    I have to select the Recent Top 2 Most  Records from One Table , Which should be selected based on the MobileNo. When i Tried to do it showed
 me  All records instead of top2... its show the old top2 ..i showed the query below and i attached the data ...which is get through the following query..
 


 QUERY :


  SELECT     RECORD_INDEX, MOBILE_ID, LAT, LON, TO_CHAR(LAST_UPDATE_TIME, 'dd/MM/yyyy HH24:mi') AS LAST_UPDATE_TIM, CURR_LOCATION  
  FROM         Ts_IDEA_LOCATIONS
  WHERE     (MOBILE_ID = '8680068953')
  ORDER BY LAST_UPDATE_TIME DESC





                         Find the attachment   ....Resultant data, and i have mentioned my Required data ... The selection should be MOBILE_ID Only 




  Guide me if Possible ... 




   -Ernesto Karthik




   


     

 



















Attachment: query.zip

Answers (1)