views:

79

answers:

1

Postgres has a useful function called GREATEST (which returns the largest value of those passed to it, documented here: http://www.postgresql.org/docs/8.4/interactive/functions-conditional.html), is there any equivalent in SQLite?

As a note, I only need it to work with 2 arguments.

+3  A: 

SELECT MAX(1,2,..)

http://www.sqlite.org/lang_corefunc.html

konforce