Skip to Main Content
Forums

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Least function Nulls.

tbhluehornApr 5 2017 — edited Nov 3 2017

Greetings, please help me work with the Least function and Nulls.

select least (table1.DATE,table1.TIMESTAMP) as FIRST from table1.

I need to select from a dataset that includes nulls. but I need to find the LEAST of two fields.

Bot date and timestamp field include nulls.  

When date field(populated) is in least function with timestamp field(null) I need the First field to show what is in the date field.

Thank you,
This post has been answered by Frank Kulash on Apr 5 2017
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on May 3 2017
Added on Apr 5 2017
4 comments
1,081 views