Date

Page.

Windauo Funchon - . binda funcn applieas

applie&[Link]
Hanting & Ahaliytc funchians
And ouH clause used uoth Hhe cuindaan func

Aepaate identHes

8eloct colrm name (a)

lay olause>
Ranse clausS
team Aeblename

seloafuncton Deline a usind aca

Aatngate Aunctisng. Pouthiti on by
Ronkng functian
Analutc funcn a Maluatuac
 Date
Paga.

Tetminclaatea
|Expeussibm
Hhe ceendauo Aunen
apotate d on Reto

Can

uthon each paition

(ugthan CHde the
Roc8 can he Used
pandition
uaindaen fanc
mto tthoueeasyicia) ypet lout
higdh oagel t aoide

woindwn functionL
SOM yualu (enaytfc
Lead
RANK C LA G
MIN
DE M
SE-RANK()
NAX ELRST_UALUe
PERCENT- RANKC) LASí. WALVE
Cauurg

ysgnt 4unchion Rxample

Selct nsidynacat

MIN( neoo-A ) 0UER Rant'on by

MAX (naDA) 0eR00ep (panton by nau) cat anden hy
Eram TestdatQ
 Date
Page
Tetdate
&um AugCaut fmin Max
800 (56
300
Dhanti 900
\200 G00 700
|333.331 3 SOo
300
(606|33333 500
\000 333.3

Ronk'ng unetan Exanple

to appry uwtn aank'ng kncon
Selact nnald

Aank) 0001( 6rden Bynaits Pa)

sRan k"
dengeMankl) oUQ51( orde1 by [Link] as ense
Rank
) Dexcent -Ranked

nais d [Link] RankDonge. Rank ezceAf-Ranlk

200

24 3
500 5

500 5

SelectRouAumgERlotrtt P (al culate Hoo no lank

dept
 aad by g or Leg oy 2 then
Date
1 2) Page

Stact Rod-NOMBER)6E RC Ruttifion By

desc)As Dept rder oysag
Nawme Dept salau)
RANKO oUER ( Pantiion
By dept ozaen by aio
DENSE enptank
-RAA\KO oUER( Pation By
dept
evn-denaeA0nk Omp
Name
o
Rameh Fn
|Dept |Balay |Ornp-Mank
Sunesh Fin
bo,06o
Ram Fin
3
Deep Qales
Sal
Und qun n to
Hank to euch GHLU0
No n:
wind

Anayics(Ueleo )Eunchion Rxample

Salact nnidy Finst ualelhen-id oUER(Orden by
new-id ) co EihstAalae,

Nod

206
300
30 200
So6 500

00 500
NULL

Uallle
 Date
Page

Integuieo Souce distance

numha Bang Di2tence
Bong |Bong
MattyueDeh
Delh
Mothun JDelhi 150
>lune Nogp SO0
506

agpuntPan 500

Metadi 0sing lao+O &gatest)functon

Solet qsatest (sounce, deb)aast
(So ance ,dtmax(bia.
ExomTHaup

Mehod2

wfAn Ce AS

Jofn ce
ANDt SNØ StSNo
DiRteane SNG
Mum bend
Delh mottung 3
Nagpu 5

Exom> Whene > Gtaup By hauing > selact > adeabydint

 MeunlOxdeN Datt , Moth (Qidei Date )a, Mor

OrdeI By
Total. Sala desc Month( Qrde-dat
AnputL
OrdenDate&a
A0AT-o1-6) 32 D091 Feb
dan
31
33
Qoal-0) -66

Silact Sala
Selact Salary Dense_Rank)
As sank QuER(oTde1 by Sale
 Date
Page

a teble intoColumn dorta

unpoat
Note AE we hue maes ca in table ( excludÉng unpiboted coln

CouNJe Name touyye (ateg Poxice

3
Prepavcaicrnndeneuo 50o0

Sadact CausaeNana, Roosgamnong,

Anteuieu Acom (awar
Anttnuieo)
)As Qigst Table

)As SouSHCe Tahle

Suml Raice) fan caudeCaea in

)AS PiutTable (tuogImning, ttunute.)
Cause tlawe Psogiamnng utexuiew
S000 NLL

Puthon NULL
Respuaton NULL
 Date
Page

Selact
feom.
Slact coute Name, Causise (atea,Rice feom
)AS SunceTale oune
Riuot
Suunl@oice ) feaun GaurseGaby tal Roogpameurg,Antiion)
onpioo(
o u t p
Poicefn csumee Categ
Cattg In (etgamni ng, înteni'm)
JAS UapigotTable

Sata Modelstucteod teble Elexible structa ike.

Patsaeinad, Qixed Dånámic &okamarles

2Schomca
Tsicnsacon ACTD-compkanne Soima suppsat AcTDRpey
Scalability Jotti cally scaalble Hani20ntally gcaloble
(&cale-up)
ample nyssLPosteaL MongnD6 ,CaRSarMa
 Date Date
Poge Page

4latianal
SelactCoLL3e Name, Pongziamnå ng TnteAul eL eom
unpiust
Note A we haue Sedact coutUe Nlame CusAse Cates Poice fcom TuAZe
masee ca in talble
Qxcludoing unpiuoted coln Riuot (

Table CounSe
CouHSE Name npioo&

Jaue Ioxgraing jAS Unpioo+Table

Catsg in (etgamning, Snteru')
Pythan Raingaaiugt
Ratauamning 3
Anteoieun 5000
No SQL
Sada Modestucteuod telble Flexible stsuctiKo ike.
ldocaumant, ksiutokilagh
AnteuieN)) Ratudeinnd Aied Dånämic Schama-leså
Schomoa
Latansacion AcTD-(ompliance
Selact CausSeNamo, PooNamming Anttu
yieaufron ScalasilRg Ueni cally Scalabie Raable
(Scale-up) (Sccale
)As SousHC ETable Cusglanguage
Poot xample

)AS PiuGtTalble
CcausseName Anteauiee)
5000 NLL
Gooo
Puthon 2000 NU LL
NOLL
Pospautatàn.
 Date
Page

update. cOA deleke

WTTH
Selact a b,c toom Tablel)

Rea
WTTH RECURSIOE claun se.

Selact

Temp Talble - A Aemp talble i3 a

phical talale Hat
8tores the data
Seion
 Date
Page

Hanchiul Cee,e sttemant

cASe ,nteaX
(uHEtA candionL hern

wHEH\ Coni onn

Ahen aetn
ENO AS Alioscolann lavne
Selecte cushid,amaant
CASE

ELSE Anexpeiue

FromPostmant
we sllp a s

CASE Expscssan C o n c d i t

CASERXPRESSSTSN

ELSE SthenRasul
END AS eolnama
exanple!
CASE Amount
500hn

ELSE Ragelar ust

Diffeence. blw CTE Temy Table (t ) axplic lHydcke

Exists
ropscves beadicbilibsy cy Conplex quey Al ahen ausing data mulhple
Caun nt be indexe d ay modid Can haue indEKe &
Constrht.
 Date
Page

Aeble bsed on oelated

eolum

Rateun

mached
, Eu doin 4able.
Retnn alleLoAdS pAorn both table
A

uma tebie

Unton-.
mane
To apply union each Statemn
must haue
calunng
Some Data Tyype
Colkng

NION ALL-Ungon Al ARRame as

kaaps al cod inchuding dupllc,. unon bu
 Date
Page

Qndex n 8L
Snde
Clusteed Sindex'-
in table whaneue1 (0e oOcte cluaten index
in thaft Aable only
one clu3te index in
clucste indox
amCunge in alphabalica) aahone data 13

anotho1 place

mulole non dusterId. indOxe

Non in a table
The index

any speciic chepten