forum.lissyara.su

Код: Выделить всё

select
      GREATEST
      (
        `rzd_1`, `rzd_2`, `rzd_3`, `rzd_3`, `rzd_5`, `rzd_6`
      )
from
    (
    SELECT MAX( `rzd_1` ) AS `rzd_1` , MAX( `rzd_2` ) AS `rzd_2` , MAX(
    `rzd_3` ) AS `rzd_3` , MAX( `rzd_4` ) AS `rzd_4` , MAX( `rzd_5` ) AS `rzd_5` , MAX( `rzd_6` ) AS `rzd_6` FROM `razdel_table`
    )
AS `maximum`

Код: Выделить всё

mysql> SELECT GREATEST(2,0);
+---------------+
| GREATEST(2,0) |
+---------------+
|             2 |
+---------------+
1 row in set (0.00 sec)

mysql>   

Код: Выделить всё

mysql>  DESC razdel_table;
+-------------------+--------------+------+-----+---------+-------+
| Field             | Type         | Null | Key | Default | Extra |
+-------------------+--------------+------+-----+---------+-------+
| rzd_1             | int(3)       | NO   | MUL | 0       |       |
| rzd_2             | int(3)       | NO   | MUL | 0       |       |
| rzd_3             | int(3)       | NO   | MUL | 0       |       |
| rzd_4             | int(3)       | NO   | MUL | 0       |       |
| rzd_5             | int(3)       | NO   | MUL | 0       |       |
| rzd_6             | int(3)       | NO   | MUL | 0       |       |
| id_index_pade_rzd | int(10)      | NO   | PRI | 0       |       |
| url_name          | varchar(64)  | NO   | UNI | NULL    |       |
| vizible_name_rzd  | varchar(128) | NO   |     |         |       |
+-------------------+--------------+------+-----+---------+-------+
9 rows in set (0.00 sec)

mysql>    

Код: Выделить всё

mysql> select       GREATEST(         `rzd_1`, `rzd_2`, `rzd_3`, `rzd_4`, `rzd_5`, `rzd_6`       ) from     (     SELECT MAX( `rzd_1` ) AS `rzd_1` , MAX( `rzd_2` ) AS `rzd_2` , MAX(     `rzd_3` ) AS `rzd_3` , MAX( `rzd_4` ) AS `rzd_4` , MAX( `rzd_5` ) AS `rzd_5` , MAX( `rzd_6` ) AS `rzd_6` FROM `razdel_table`     ) AS `maximum`;
+--------------------------------------------------------------------------------+
| GREATEST(         `rzd_1`, `rzd_2`, `rzd_3`, `rzd_4`, `rzd_5`, `rzd_6`       ) |
+--------------------------------------------------------------------------------+
|                                                                             63 |
+--------------------------------------------------------------------------------+
1 row in set (0.00 sec)

Код: Выделить всё

select GREATEST( MAX(`rzd_1`), MAX(`rzd_2`), MAX(`rzd_3`), MAX(`rzd_4`), MAX(`rzd_5`), MAX(`rzd_6`) ) AS 'maximum'  FROM `razdel_table`;