Rеja Axborot tizimlari va ma'lumotlar bazasi

SELECT name, density*1000, elastics*1e+9 FROM materials;

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

| name         | density*1000 | elastics*1e+9   |

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

| steel        |      7800.00 | 200000000000.00 |

| aluminium    |      2700.00 |  65000000000.00 |

| concrete     |      5600.00 |  25000000000.00 |

| duraluminium |      2800.00 |  70000000000.00 |

| titanium     |      4500.00 | 116000000000.00 |

| brass        |      8500.00 |  93000000000.00 |

+--------------+--------------+-----------------+
1-jadval. Arifmetik funksiyalar

Sintaksis	Qaytaruvchi qiymat
ABS(x)	X ning absolut qiymati
SQRT(x)	X ning kvadrat ildizi
MAX(x, y, ...)	x, y, ... sonlarining eng katta qiymatini topish
MIN(x,y, ...)	x, y, ... sonlarining eng kichik qiymatini topish

 Izoh. x, y - sonli natijaga ega bo'lgan raqamlar yoki iboralar.