Posted by Doug on 02/01/06 03:36

SELECT MIN(klugger)
FROM Foobar
WHERE klugger IS NOT NULL


won't that require a table scan unless there is an index on klugger?

• Next in forum: Re: How to find first not null value in column
• Prev in forum: front end options for entering data into an oracle database
• Thread view: Re: How to find first not null value in column

[Reply to this message]