Greatest and Max in sql
824556May 17 2011 — edited May 17 2011greatest means it take the high value frm the exprn,,,,isnt it?
so in this eg: SELECT greatest('22', '5', '60', '1000','1') FROM DUAL;----------Ans is : *60*
select GREATEST('aby', 'john', 'faisal') from dual; --------Ans is john
how it get these outputs outut,,pls help me
and how to find the greatest or higest date from one table using greatest function,
pls explain with an example
thnz
Edited by: 821553 on May 17, 2011 3:16 PM
Edited by: 821553 on May 17, 2011 3:23 PM