MySQL: get maximum an minimum values in ONE query

Question

hi folks,

i'm searching for a way to get from two coloumns (lets say: posx and posy) the global (whole table) maximum and minimum with just one query.

Database is MySQL

thanks

Answer 1

 select max(posx), min(posy) from table

Answer 2

SELECT
    MIN(colx) AS minimum,
    MAX(colx) AS maximum,
    MIN(coly) AS minimum,
    MAX(coly) AS maximum

FROM table

Answer 3

Simple:

SELECT MIN(posx), MIN(posy), MAX(posx), MAX(posy) FROM table

Answer 4

It's really no more complex than it sounds.

SELECT MIN(posx), MAX(posx), MIN(posy), MAX(posy)
FROM yourtable