Compare three columns in a SQL table to get middle value

Question

I need to display the middle value of three columns in a sql table.

eg: For data

col1    col2    col3
759     736     773

Then output should be 759.

What is the best way to do it?

Answer 1

For Oracle, MySql and Postgres:

select col1 + col2 + col3 - greatest(col1, col2, col3) - least(col1, col2, col3)