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

Karthik Che

Jul 19 2013 2:02 AM

1.2k

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