sql standartlari

PPTX 15 стр. 1,5 МБ Бесплатная загрузка

Предварительный просмотр (5 стр.)

Прокрутите вниз 👇
1 / 15
wps presentation union, intersect va minus standart so’zidan foydalanish. standart funksiyalaridan foydalanib so’rovlar yaratish. agregat funksiyalaridan foydalanish. reja: 1. union, intersect va minus standart so‘zlaridan foydalanish. 2. standart funksiyalardan foydalanib so‘rovlar yaratish. 3. agregat funksiyalardan foydalanish union, intersect va minus standart so‘zlaridan foydalanish. union funksiyasini ishlatilishi: select * from teachers union select * from ustozlar; intersect funksiyasidan foydalanish: select id from teachers intersect select id from ustozlar; except(minus) funksiyasidan foydalanish: select id from teachers except select id from ustozlar; standart funksiyalardan foydalanib so‘rovlar yaratish. upper() funksiyasini ishlatilishi: select upper(names), id, live_in from teachers; lower() funksiyasidan foydalanish: select lower(names), id, live_in from teachers; lpad() funksiyasidan foydalanish: select lpad(names, 20, ‘#’) from teachers as newareas; rpad() funksiyasini ishlatilishi: select rpad(names, 20, ‘$’) from teachers as newares; ltrim() va rtrim() funksiyalaridan foydalanish: select id, name, ltrim(name), live_in, rtrim(live_in), expriences from teachers; length() funksiyasini ishlatilishi: select names, length(names) from teachers; left(), right() funksiyalaridan foydalanish: …
2 / 15
siyasidan foydalanish: select id, names, rand(id) from teachers; round() funksiyasidan foydalanish: select id, income, expriences, round(income/expriences, 4) from teachers; power() funksiyasi orqali sonni darajaga ko’tarish: select id, expriences, power(id, expriences) from teachers; sin() va log() funksiyalarini ishlatilishi: select id, names, sin(id), log(id) from teachers; sqrt() funksiyasi orqali sonning kvadrat ildizini hisoblash: select id, income, sqrt(income) from teachers; image1.jpeg image3.png image4.png image5.png image6.png image7.png image8.png image9.png image10.png image11.png image12.png image13.png image14.png image15.png image16.png image17.png image18.png image19.png image20.png image21.png image22.png image2.jpeg §b laboratoriya - postgresql-one’ x = + v _ x € > cg @ onecompiler.com/postgresql/3y4zhj4my apps if gmail > youtube [g translate © maps [| programming %& settings- passwords [j tatu [mm english commands.sql laboratoriya # new c stdin 2 create table teachers (id int, name varchar(30), live_in varchar(2@), expriences int, inc : input for the program ( optional ) 5 select * from teachers; e@ 6 insert into teachers (id, …
3 / 15
ustozlar; 2 | botirov abdusamat | navoi | 2 | 22ee00ee 19 3 | begalieva holida | namangan | 4 | 2300000 2@ select * from teachers union select * from ustozlar; 4 | hakimov halimboy | andijon | 5 | 3ee0000 21 --select * from teachers except select * from teachers; (4 rows) 22 23 24 id | name | | | income 25 alt ella tattattatat + + settee ca 1 | alixonov odilxon | jizzax | 3 | 12ee00e0 2 | fozilova zebo | fergana | 4 | 2350000 3 | jabborov asliddin | sirdaryo | 9 | 5eeee0ee 4 | olimov javohir | khorasm | 6 | 4550000 (4 rows) id | name | live_in | expriences | income §b laboratoriya - postgresql-one’ x = + v _ x € > cg @ onecompiler.com/postgresql/3y4zhj4my @e * & # o c:) 5 apps if gmail > youtube …
4 / 15
| | 1 3 | 5 |e 21 --select * from teachers except select * from teachers; 7 name tve_in expriences income 22 - - 23 1 | alixonov odilxon | jizzax | 3 | 12e0000 x 2 | botirov abdusamat | navoi | 2 | 22ee00ee 36 4 | hakimov halimboy | andijon | 5 | 3ee0000 27 1 | aliyev islom | bukhara | 12 | 4ee0e0e0ee 4 | olimov javohir | khorasm | 6 | 4550000 2 | fozilova zebo | fergana | 4 | 2350000 3 | begalieva holida | namangan | 4 | 23e0000 3 | jabborov asliddin | sirdaryo | 9 | seeee9ee (8 rows) 8 3y53bdmuz - postgresql -one x == ‘postgresql - intersect operat x | ++ v - x cg @ onecompiler.com/postgresql/3y53bdmuz apps if gmail > youtube [g translate © maps [| programming %& settings- passwords [j tatu [mm english commands.sql …
5 / 15
| 4 | 2350000 23 56 | jabborov asliddin | sirdaryo | 9 | 5eeeeee x 3 | olimov javohir | khorasm | 6 | 4550000 26 (4 rows) 27 28 id 3 2 (2 rows) 8 3y53bdmuz - postgresql -one x == ‘postgresql - intersect operat x | ++ v - x cg @ onecompiler.com/postgresql/3y53bdmuz apps if gmail > youtube [g translate © maps [| programming %& settings- passwords [j tatu [mm english commands.sql 3y53bdmuz # new create table teachers (id int, name varchar(3@), live_in varchar(2@), expriences int, inc oan input for the program ( optional ) (1, ‘aliyev islom', ‘bukhara', 12, 4900000), (2, 'botirov abdusamat', 'navoi', 2, 2200000), (3, "begalieva holida', ‘namangan', 4, 2300000), al 2 3) 4 insert into teachers (id, name, live_in, expriences, income) values 5 6 7 8 (4, "hakimov halimboy', ‘andijon', 5, 3000000); 1 | aliyev islom | bukhara | 12 | 4eeee0e0 e …

Хотите читать дальше?

Скачайте все 15 страниц бесплатно через Telegram.

Скачать полный файл

О "sql standartlari"

wps presentation union, intersect va minus standart so’zidan foydalanish. standart funksiyalaridan foydalanib so’rovlar yaratish. agregat funksiyalaridan foydalanish. reja: 1. union, intersect va minus standart so‘zlaridan foydalanish. 2. standart funksiyalardan foydalanib so‘rovlar yaratish. 3. agregat funksiyalardan foydalanish union, intersect va minus standart so‘zlaridan foydalanish. union funksiyasini ishlatilishi: select * from teachers union select * from ustozlar; intersect funksiyasidan foydalanish: select id from teachers intersect select id from ustozlar; except(minus) funksiyasidan foydalanish: select id from teachers except select id from ustozlar; standart funksiyalardan foydalanib so‘rovlar yaratish. upper() funksiyasini ishlatilishi: select upper(names), id, live_in from t...

Этот файл содержит 15 стр. в формате PPTX (1,5 МБ). Чтобы скачать "sql standartlari", нажмите кнопку Telegram слева.

Теги: sql standartlari PPTX 15 стр. Бесплатная загрузка Telegram