O’zbekiston Respuplikasi Axborot

O’zbekiston Respuplikasi Axborot

Texnologoyalari va Komunikatsiyalarini Rivojlantirish vazirligi Muhammad Al-Xorazmiy Nomidagi Toshkent Axborot

Texnologoyalari universiteti

A.T Kafedrasi

Ma’lumotlar bazasi Fani Boyicha

Labaratoriya-3

Bajardi: _________________

Tekshirdi: Asqaraliyev O

Toshkent 2020

DELIMITER $$

CREATE FUNCTION SUMMA(A INT, B INT)

RETURNS INT

DETERMINISTIC

BEGIN

DECLARE C INT;

SET C=0;

SET C=A+B;

RETURN C;

END$$

DELIMITER;

DELIMITER $$

CREATE FUNCTION GIPATENUZANIHIS(a INT, b INT)

RETURNS INT(20)

DETERMINISTIC

BEGIN

DECLARE c INT(20);

SET c=0;

SET c=sqrt(a*a+b*b);

RETURN c;

END$$

DELIMITER;

DELIMITER $$

CREATE FUNCTION SONNIFOIZHIS(N INT, K INT)

RETURNS INT(20)

DETERMINISTIC

BEGIN

DECLARE NATIJA INT(20);

SET NATIJA=0;

SET NATIJA=N*K/100;

RETURN NATIJA;

END$$

DELIMITER;

Jadvallarni birlashtirish. INNER JOIN, LEFT JOIN, RIGHT JOIN, FULL JOIN.

Jadvallarni birlashtirish. INNER JOIN, LEFT JOIN, RIGHT JOIN, FULL JOIN.

Jadvallarni birlashtirish. INNER JOIN, LEFT JOIN, RIGHT JOIN, FULL JOIN.

Jadvallarni birlashtirish. INNER JOIN, LEFT JOIN, RIGHT JOIN, FULL JOIN.

Jadvallarni birlashtirish. INNER JOIN, LEFT JOIN, RIGHT JOIN, FULL JOIN.