Select max(id) not returning correct value

From: Kean Jacinta <jacintakean_at_yahoo.com>
Date: Thu, 19 May 2005 20:22:47 -0700 (PDT)
Message-ID: <20050520032247.69748.qmail@web52903.mail.yahoo.com>

Hi ,

I found that the select max(id) from tablename does not give me the correct value.

My current table has

ID
--

1
2
3
4
5
87
95

All this id is namually inserted. When i query

select max(id) from mytable;
It will not return 95 instead it will return value 5 ?

Anyone encounter this problem before?

JK                 

---

Yahoo! Mail Mobile
Take Yahoo! Mail with you! Check email on your mobile phone. http://mobile.yahoo.com/learn/mail
--

http://www.freelists.org/webpage/oracle-l Received on Thu May 19 2005 - 23:27:31 CDT