sql standartlari

PPTX 15 sahifa 1,5 MB Bepul yuklash

Sahifa ko'rinishi (5 sahifa)

Pastga aylantiring 👇
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 …

Ko'proq o'qimoqchimisiz?

Barcha 15 sahifani Telegram orqali bepul yuklab oling.

To'liq faylni yuklab olish

"sql standartlari" haqida

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...

Bu fayl PPTX formatida 15 sahifadan iborat (1,5 MB). "sql standartlari"ni yuklab olish uchun chap tomondagi Telegram tugmasini bosing.

Teglar: sql standartlari PPTX 15 sahifa Bepul yuklash Telegram