TECHNOLOGIES
FORUMS
JOBS
BOOKS
EVENTS
INTERVIEWS
Live
MORE
LEARN
Training
CAREER
MEMBERS
VIDEOS
NEWS
BLOGS
Sign Up
Login
No unread comment.
View All Comments
No unread message.
View All Messages
No unread notification.
View All Notifications
Answers
Post
An Article
A Blog
A News
A Video
An EBook
An Interview Question
Ask Question
Forums
Monthly Leaders
Forum guidelines
Karthik K
1k
738
192.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
Reply
Answers (
1
)
Oracle Query
how to find missing numbers in a sequence?