Guide-yakabatana mibvunzo · Pakati Nhanho
Maitiro ekunyora SQL Window Mabasa neAI Quiz
Tarisa SQL windows partitions, zvisungo zvekuisa uye anomhanya-akazara mafuremu ane mienzaniso yekutenga, misi isipo uye ichangoburwa-chiitiko kusarudzwa.
Mubvunzo 1 ye 8
Pakutenga kwakaodha kwe5, 7 uye 4, ndedzipi mutsara-ne-mutsara dzinomhanya dzinoenderana nefuremu yegwaro?
Tarisa mubvunzo wese8 mibvunzo
Mhinduro uye tsananguro zvinoonekwa paunenge uchitora bvunzo.
- Pakutenga kwakaodha kwe5, 7 uye 4, ndedzipi mutsara-ne-mutsara dzinomhanya dzinoenderana nefuremu yegwaro?
- 5, 7uye 4
- 5, 12 uye 16
- 16, 16 uye 16
- 5, 14 uye 12
- Pakudzika zvibodzwa 100, 100 ne90, ndeipi inotevedzana inoburitswa neRANK?
- 1, 2 uye 3
- 1, 1 uye 2
- 2, 2 uye 3
- 1, 1 uye 3
- Nderipi basa rinopa zvibodzwa zvakasungwa 100, 100 uye 90 nhanho 1, 1 uye 2?
- DENSE_RANK
- ROW_NUMBER
- RANK
- LAG
- Muvhunzo wechiitiko uchangoburwa unoshandisa ROW_NUMBER yakarongedzwa chete nechitambi chenguva chakagovaniswa nezviitiko zviviri. Chii chinodiwa pasarudzo inofanotaurwa pakati pavo?
- Bvisa chikamu cheakaundi
- Tsiva chigumisiro chekupedzisira neisina kukodzera DISTINCT
- Wedzera yakakodzera tie-breaker kurodha yehwindo
- Fungidzira odha yekuisa inogadzirisa tie yese
- Sei LAG yekutengesa kwemazuva ese ichitadza kumiririra kutengesa nezuro?
- LAG inogara ichireva mutsara wekutanga wetafura yese
- Mutsara wakare wakarekodhwa unogona kuparadzaniswa nemazuva asipo
- LAG inozvibatanidza mazuva ese mumwedzi mumwe
- Basa racho rinotsiva mazuva asipo ne zero
- An ORDER BY inowanikwa mukati OVER. Chii chichiri kudikanwa kana yekupedzisira yakaratidzwa mhedzisiro ichifanira kuve neyakatarwa?
- Chete CHIKAMU BY chine koramu imwechete
- Chete ROWS furemu inoshandisa iyo imwechete yekurongeka koramu
- Hapana imwe clause nekuti kuodha kwehwindo kunovimbisa kuratidza kurongeka
- Yekupedzisira ORDER BY yemhinduro yemubvunzo
- Sei munhu anotyora tie asingawedzerwe zvisina tsarukano kuRANK kana zvibodzwa zvakaenzana zvichifanira kugovera chinzvimbo?
- Inogona kushandura mitsara iri vezera uye saka shandura yakasungwa mitsara
- Inosiya nhengo yevezera isina kuchinjika nekuti iyo yekutanga yekuodha koramu ndiyo inonyanya kukosha
- Inoshandura chete yekupedzisira kuratidza kurongeka uye kwete iyo hwindo kuverenga
- Iyo inochengetedza yakaenzana-nhamba-yepakati apo ichiita otomatiki nhamba dzemitsara yavo kufungidzira
- MuPostgreSQL, ungaite sei mitsara yekusefa uchishandisa kukosha kwehwindo kuverengerwa mukati SELECT?
- Shandisa kukosha ikoko mune imwechete SELECT's WHERE pasina imwe nhanho yemubvunzo
- Tsiva OVER neGROUP BY mune zvese
- Sefa mumubvunzo wekunze kana mataurirwo etafura
- Fungidzira kuti dhatabhesi yega yega inotsigira yakafanana QUALIFY clause