Wednesday, 31 October 2012

Oracle SQL - GREATEST and LEAST

To select max from 2 columns
select greatest(4,2) from dual

To select min from 2 columns
select least(1,3) from dual
-
Labels: , ,

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)

Integrations Lead - Lessons learnt

 Integrations have been my passion for a while but like anything tech there is no credit given when things go right but always heaps of pres...