InoteveraGaidhi rinotevera
Maitiro ekunyora SQL CTEs uye Subqueries neAI
Tekinoroji
Nhungamiro yehunyanzvi
AI inogona kubatsira kunyora SQL hwindo mabasa ezviyero, kuenzanisa uye kumhanya kuverenga uchichengetedza mitsara yemhedzisiro.
Teerera kugwaro iriAI-yakarondedzerwa · ~3 min
Kuti uwane mubvunzo wakavimbika, tsanangura kupatsanurwa, kurongeka, tie maitiro uye furemu pane kubvunza chete iyo inomhanya yakazara kana yepamusoro mhedzisiro.
Aggregate yakaunganidzwa kazhinji inoderedza mitsetse yakati wandei kuita mugumisiro mumwechete paboka. Kuverengera kwehwindo kunogona kubatanidza huwandu hweboka, chinzvimbo kana kukosha kwevavakidzani kumutsara wega wega. Izvi zvinoita kuti zvive zvakakosha kune mishumo inoda zvese zvakadzama uye mamiriro, senge kutenga kwega kwega padivi pekushandisa kwemutengi. Ipa iyo AI injini yedatabase, makoramu akakodzera uye inotarisirwa kuburitsa kwediki dataset. Zvadaro tsanangura sarudzo ina. Chikamu chinotaridza kuti ndeapi mitsara iri pamwe chete, sezviitiko zvese zveakaundi imwe. Kurongeka kunoratidza kutevedzana kwavo. Basa rinotsanangura kuverenga. Pamafunctions akanganiswa nefuremu, furemu inotaridza kuti ndeapi mitsara iri mukati mechikamu ichibatsira kune zvazvino. Zvirongwa zvezvinzvimbo zvinobata zvisungo zvakasiyana. ROW_NUMBER inopa mutsara wega wega nhamba yekutevedzana kwakasiyana, asi yakasungirirwa kukosha kwekuodha kunoda tie-breaker yebasa rinozivikanwa. RANK inopa zviyero zvakaenzana kune vezera vakasungwa uye inosiya mikaha mushure. DENSE_RANK inopa zviyero zvakaenzana pasina mikaha iyoyo. Sarudza zvichibva pane zvinorehwa nemushumo. Huwandu hwekumhanya hunoda kunyatsotarisirwa. Iwindo rakarongedzerwa rinogona kuve neyakagadzika furemu iyo inosanganisira vezera vane yakaenzana yekuraira kukosha. Pahuwandu hunofambira mberi mutsara mumwe panguva, tsanangura yakakodzera ROWS furemu uye deterministic order. Edzai dzakasungirirwa zvitambi zvenguva pane kuvimba chete nemhando dzakanyatsosiyana dzemuenzaniso. LAG inoreva mutsara wepakutanga mukurongeka kwechikamu. Haingozadziki misi yekarenda isipo. Kuenzanisa kwekare-mutsara saka kunogona kusiyana kubva kune yapfuura-yezuva kuenzanisa. PostgreSQL's windows-function tutorial inonyora misiyano iyi. Bvunza iyo AI kuti itsanangure sarudzo dzayo, ita mubvunzo pane diki gadziriso, uye enzanisa mutsara wega wega nechero inotarisirwa chinzvimbo kana huwandu usati waishandisa kune yakakura mushumo.
Mudzidzi anokumbira PostgreSQL inokwana kudarika matatu akaodha kutenga anokosha 5, 7 uye 4. Iine mutsara-yakavakirwa furemu kubva pachikamu chinotanga kuburikidza nemutsara uripo, huwandu hunotarisirwa i5, 12 uye 16.
Pazvibodzwa 100, 100 ne90 zvakarairwa kubva kumusoro kusvika pasi, RANK inoburitsa 1, 1 uye 3, ukuwo DENSE_RANK ichiburitsa 1, 1 uye 2. Uyu muyenzaniso mudiki unoita kuti tie maitiro aonekwe.
Chirevo chinofananidza kutengesa kwechitoro chimwe nechimwe nezuva rayo rekare rekodhi uchishandisa LAG. Munyori anotarisa mazuva asipo nekuti mutsara wapfuura haufanire kumiririra nezuro.
Muongorori anobvunza AI kuti isarudze chiitiko chazvino paakaundi yega yega uchishandisa ROW_NUMBER, ine chinozivisa chiitiko sechinotyora tie kana zvitambi zvenguva zvichienderana. Mhedzisiro inoedzwa pamatampu akasungwa nemaune.
Vabatsiri vemibvunzo vanogona kuvandudza tsananguro dzewindow-basa nekuratidza kupatsanura uye furemu padivi pemhedzisiro yakaverengerwa. Kusvikira hunhu ihwohwo hwakavimbika, zvigadziriso zvidiki zvine zvisungo, mazuva akashaikwa uye mapoka emutsara mumwe anopa nzira yekuongorora inoshanda. Zvikwata zvinofanirwa kuchengeta iyo mienzaniso nemibvunzo yavo yekuzivisa kuitira kuti kupepetwa kweramangwana kuchengetedza chirevo chavanoda. Sezvo mushumo uchikura, kushanda kunodawo kuyerwa pane data inomiririra. Kupfupika kwewindow kutaura kunogona kuramba kuchida kurongeka kwakakura, uye mhedzisiro inoita seyakanaka haigadzirise kumhanya kwekugadzira kana hunhu chaihwo pane yega yega kesi.
Tsamba yemahara
Nhatu dzakasimbiswa dzeAI nyaya mangwanani ega ega pakati pevhiki, dzakanyorwa neChirungu chakajeka. Yemahara zvachose, hapana ads.
Imwe email zuva rega rega revhiki. Bvisa kunyoresa kamwe chete. Hatimbotengese kana kugovera kero yako.
Zviedze iwe pachako
Mhinduro yepakarepo pamhinduro yega yega, uye chitupa chinogovaniswa chine ID inobatika kana wapedza kosi.
Tsigira dzidzo yemahara yeAI. AI Understanding ndeye 501(c)(3) isingabatsiri - hapana ads, hapana paywall, zvachose. Ita chipo
AI inogona kubatsira kunyora SQL hwindo mabasa ezviyero, kuenzanisa uye kumhanya kuverenga uchichengetedza mitsara yemhedzisiro. Kuti uwane mubvunzo wakavimbika, tsanangura kupatsanurwa, kurongeka, tie maitiro uye furemu pane kubvunza chete iyo inomhanya yakazara kana yepamusoro mhedzisiro.
Mutsara wega wega unosanganisira mitsara yekutanga uye pachayo, ichigadzira huwandu hwe5, 12 uye 16.
Zvibodzwa zviviri zvekutanga zvakasungwa pachinhanho chekutanga, uye chinzvimbo chinotevera ndechetatu nekuti RANK inosiya mukaha mushure mezvisungo.
DENSE_RANK inopa zviyero zvakaenzana kune vezera pasina kusiya mukaha weukoshi unotevera wakasiyana.
ROW_NUMBER inoda kurongeka pakati pemitsara yakasungirirwa kana chiitiko chakasarudzwa chichifanira kufungidzira.
LAG inotevera mutsara kurongeka, saka zuva rakashaikwa zvinoreva kuti mutsara wekare unogona kubva pane yekutanga zuva kupfuura nezuro.
Ramba uchidzidza
Mamwe madhairekitori akasarudzirwa nyaya iyi
InoteveraGaidhi rinotevera
Maitiro ekunyora SQL CTEs uye Subqueries neAI
Tekinoroji