Rеja Axborot tizimlari va ma'lumotlar bazasi

SELECT id, n1, n2, n3, MAX(ABS(n1-n2),ABS(n1-n3),ABS(n2-n3))

    FROM elements;

+----+----+----+----+---------------------------------------+

| id | n1 | n2 | n3 | MAX(ABS(n1-n2),ABS(n1-n3),ABS(n2-n3)) |

+----+----+----+----+---------------------------------------+

| 29 | 24 | 26 | 25 |                                     2 |

| 30 | 24 | 25 | 23 |                                     2 |

| 31 | 22 | 26 | 24 |                                     4 |

|  1 |  2 |  3 |  5 |                                   &nbs

p; 3 |

|  2 |  1 |  2 |  4 |                                   &nbs

p; 3 |

|  3 |  2 |  5 |  4 |                                   &nbs

p; 3 |

|  4 |  4 |  5 |  6 |                                   &nbs

p; 2 |