How to Select Recent Top of the Query ?..In Oracke
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