Scribd
Upload
2 views41 pages

SQL Notes

The document provides an overview of SQL (Structured Query Language), detailing its history, syntax, and various sublanguages such as Data Definition Language (DDL), Data Manipulation Language (DML), and Data Control Language (DCL). It explains how to create, modify, and delete database structures and data, along with examples of SQL commands. Additionally, it highlights the non-case sensitivity of SQL and the importance of using semicolons to end statements.

Uploaded by

abdyshuu599
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF or read online on Scribd
2 views41 pages

SQL Notes

The document provides an overview of SQL (Structured Query Language), detailing its history, syntax, and various sublanguages such as Data Definition Language (DDL), Data Manipulation Language (DML), and Data Control Language (DCL). It explains how to create, modify, and delete database structures and data, along with examples of SQL commands. Additionally, it highlights the non-case sensitivity of SQL and the importance of using semicolons to end statements.

Uploaded by

abdyshuu599
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF or read online on Scribd
® S@LC Stuctused Query hong uage ) “Gd L_2- S@Lis_o-non. procd veralLanguoge— — which was inboduced by the IBrM_in 1970'S. Which is used do Communicote with _clatabase. -=[Link] Giled as sequeal_o#. -CLI_lomguage. CCommen Language. Sintea face), This. is_only —the_language “which Gn_use ty Gmmunigte _ —With any RDBMs_ peoduck. d = i. xz. ep "ES ee aol ee uses - Pi = LE] ray sat} a -~G@L_ is not _Ca Se Sensitive languoge thot we -Gn_osite_SaL predefined quesiés ox —Syntoxes ta-6 ec. charac tenis-C eithear DPE ox | Jowers) é al | . sae es ® - byeey Sal Statement should ends ith g semicolon —but this o pRonalin sa i eee Sublanguages of Ss@L Ay ® Dat a Defnato n_han guog e CDDL) * G@eate : _« Albens_ ng « Sp_ Remame ® Jam cote. be dy 45 © Dep - a] Data Monupulak on_language COL) ° Imsea+ ¢ UpDate * Delete — ®_Dota _ Quem Language. DMI) ——~ * Select Q. Teonsachon_Gnbol_languege-CtelL>——— - * Commit oS —* RoliPianfe ab 2 Sovepoimd — (a © Dota Gnbol Language CDCl —————— Game ie he get e peabne ~~ Rewtoke i) a 2 hee cote hee aa “>his- lomguoge Goeaeentle ee tata define, | modify 4 Dep on anil ot Cotobase. fom SQL sees. mera fleeces a O _Coreale. B= = Cen anew. Heloehal sc eet ~——table_in SQL. Sewer —___ Step i §- Greate _o new « dolobase In.Sal_Seven_ “—Syntaa 2= Coeate database b= [Link], MYDR 4 Step 22- Select Th e_sequined doichasaflam —___________Sml Sewers. _ —— “Syntax $-__Use : pase, i= Ue. asp Step 3_i- _Cacote new toble in datohose > ~—Syntox 8 - Create +toble__ [size] - ~-- Paes ~_Ex 8- Create. Seine. ve a "Snare. chore Clod 5 < “AGE Tingint 5 ura sNiiio a 1806 Columns emt CSid ant, - Sfee Decimal C6, 03.— — a —Stepy Se $= “To View the Struchres of of ia ble — Syntax % SS ee Ghia me Se- Ex 2-__§[Link]@lp Shudemb 3 yl are ee te ©. | ta paecleRned. | gp-HeLpts poe “Reed. Steomecl poset omatadina ae_| ‘i |; LIER. 2= “To_chonge._o& modi thes il @ POO Sy cheshire of stable_ov a_clalobase . iz i Fy vst ng the_Alten Command We. Cin Peafiben o following. -fbuce_opercahions _on existing table | _1d. penifréarn these opemotonS wea gui red | supcommoamds of alten. | i> Albene = Alters Column si) Allene Add [. iid _Sp- Rename. IF iv) ALTER = Denop Ly fee 2) Alles = Altea Column _’= Te chonge datdypef clso_Sizo.of the datatype _o: rei lomn+—~ yotac $= Af Altes _toble £TN> Alter Column < Coluren Name.>_| PNew Size): L ~ - I Ex%- Alters table Shident Altea: Column SName- — Noaschonr_C:500 3 — ; — | 1) Altear- Add $= Adding “pnec> Column to.add_+ Saisk -tclole = 7 Synlaxs- Altes doable ZTN> App £nNew Blumen — Nomo> ADT>[si2e15 ———~ TL ft Allen “Table Ghent App Saddle ss ———~ —Norrahane C&D _G@-Column A. Syntaa -[Link]— ALD. "el a Sp. Remame- éTable Name * ~New Column —Hamaa 2 jo BE “But-tBpsRemime © ¢ < [Link]. rE Namna$ 7 3 Lis cyritene Ha chongeo tabla. Sanaa. in Setohag epee t?, 2 Neco tohiel Name 2? 3 Jal 7 oma < chidemb?, tshiddlemidetoile? | 4 oR. : i Sp-Remame. * Stuclemtdetoile” 2, Shaler al “_aw) ALTER = Dap: 3 ESS 3 ___ the +toblo_ 4 ping —a_ item fiom Syntax t= Alter table £ Table ‘ y fac —Glumn_< ColumnName> 3 ama Pimp Ens uae Colin: we (mnmcate_£= Deleting ans fom tha toble, bub. | _ rol [mo Ye Siucile tthe lake, br using Aronia | commend We. Can not delete.a specific anid | for the table. because. it dosent Guppost | H , « Wheare” Clouse Gondihon. | I “Syntax. $= “Famcote table. ¢TableNome? : | | ee s- Famcate. table Studemd- | | E 6 Duep t= Dampping 0 table. firma _datchase. | _ _peasmomatly w Syntece-_Danp table. < Table Namo-73 ees Dapp =toble Student pe ete! Opmit- Mata Manu pulation longus. qed _ L This language Gxramends_oaev sed_do __- L Change ot —-naamipulate dato_in_datobose. table. Lay “Ingen 2= “Imsenting oe 2 20a into _a— Mable. There. dare te methods to inset — ‘ ‘. q e ‘ye ad sate LTDLdS. te BE “> Timplicit Method “b- Tmseating ct — volue! “Columns indootoble 6 ‘Without left a Cluran? po : | LtobleName.> Values [L c Nine p Slatin, Nase a = i aa Tal —Ett- orn doble- Shidenk “(Carr inks ee, ay _Naxchaer Cue) 5_ oie decimal C622.) 5A: -dingsn +) path a taba be ete UO SA EI Spe Egle ret + a eee kee ee Inset. Ninh “shdemt Values. UCdolsi*SA 26005 91) — a “teases | Studem+ Vi Volga (loo > “sa mes», 4600 , 93) i a ate ® iy Beplicde Method &- Thserking: values | far wequittcl_Cluran's_ a | —Olumn_in the +oble> —~Syntox t= heme Canitn) tabla etna leu ——Glumn NomeS) Vajues Clo® ¢ Au, “Hota: to Fosent-_Muts iia Ss 5 a - Syntax firs - ~ chases _CIntol. tb letra lagna ak -—Maluo S >» CRORE welea) ace 2 ar “Snitch ina Shenk vole ¢ C16 [800,999 , Clogs < hWoaccl? , logo —Syolox fom Bopitcih sa ao —inseot [1 HI01 ¢toblenom, a —Names) Waluos (Rois values), C Ried a, Na teal J Ex t= Fnserct- student C5122 values Clo62, C10? Tey ~ ae ~ = ~ ——- 4 © update == updating all sows data ino_ ! | toble_ota+me oe a Specific wo deta i atoble by Using. ¢Where’ Gnditon Syntoot 3- ai ts update. < Table Name> Set <¢ ClumnName4>?: = - a=: CF Hheme Gmndition 35 Gt= bait co quenp to fe @rnployee job OS HR, Galosy as 1, 000_@& WhdS employer Numbers_is_ 7788 | uptate Set Job = ¢HR’*, Salaay =14000_ bE hens Empno = 7788 S Beis hlathe _a_queay to update, all. Cam ployee Gromition. 10S _500- = i updote._Emp Set Comm = 500_ | © f Delete $- __Deledin ‘A alms fromdhe-— be able ot a timo. ow_a_Specifi cap from —_— i “the. table_by Usinguhexe._Cla use_Gmditon— Syntgqn B= _ — “Delete form L Tal eN amo» ChJheae =Seleck # roi Edame. Dede ‘Phlorae, 7 hike £%N7." Escape “AN Gat ee el ;: Oe dispioy. omplayee Hhss. Nome js we i _—having- h_sycn bo) ee | = Select * fom Ears Emp lhexe. loma. p_—_______liko. of. N77 =a. RED ho _©- To_dis Play emp ee b ith tt oak Pe sr Hl Sarna forts Sa _Geienk 4 # = inrin Edina: dull, —“Witeo, * CAs 0, Pt, tel yd eo [Link] “Nok lte, & reer irae ak so Bee Hite. a_gu cto} levy ee __ Lhe's_ ame rast ae foal , aoleiels ___Choca oo gg ee a = Select? fora. Brame i ke §S%? heme Boeimne. pab > al \pencatos'’s $= Jo opesetoaS are. Used 40 -aehrive. dhe-ctlta—— com _singletable_o multi ple dable.s ta —§_| “yeni yf tt these. opersatoss Omest np oo - ®_union = . — ®_ ynion_all —— LC __ _. @®_ Tterseck— eer) |) a ® Excaph = i | “O union 8=.db tahvems cull _volussfroma_all —; Sets vithout—l uplicake! 5 a © Umonol_t- th Betutms_all_v lass froma} ——- Sets including — alup Nantes. “ + © -plergeck 8- tt tohems Gmmon Valls © opt % — Th -tohwemS_Undamyrnon—Va [usS ror; ~ the lop [Link] b but node ight-side.—— i xn t a Bumple on Sed oO persoa's_aith single. ble —} yntay + — L 4 Sele ch F Fomn_< Fabs le Are’ EE ~—~| pene. ondition? 1 Oo “Union! Bee eee “eso Select job Pass. Emp. “blhere_ pepbiias Zig ———Vhion____ Select "yee. frm Bop Jun exe. Deptiasay ited. - SO p —_Depkno 5. 2 tes cary ee Deptno 206. J i “gee eer a —PreSidemn+ —___ J Monagent -———Cleawsk —Anolyst__— a | Manage 2 4 nClewk "© ‘mien toll 22 ie le | fet= Seleck Tob eee. =lo. Prom np he ea Unian_all_. Select gob ns “here. Depisto a = 26 eS ipbenkeenhs te $18 hey seu tes eh [ “_Bri- Select Job _ woo Eme _Ilherne. 1 a i= Select ch fiom Bop Linens. Daphsaty ees —— Salen eee eplila saa ‘ Saree re on _se+ operahaie, “aith ulti sles apres 8 ect te poly a _ Select4 * from "qableNawieds Others. t Fikes od 404 opemater > _____ ~Geleck fiom 2 Tabiename 2>| Qharetindifyen ens OO er ® G3- Cocote. able Emp_hyD CEP yrdt fr Selace * from Erop yD. et ——. SEntearsech— ae —_——__ ae Siete coe quesy- to iia; & eno pi Hi — ¢—taowking —in. a Ie notin Chennol_baanch- | ar p= sel ject % eG : Eccope + Ws —Seleck a — aes mnt »—Who_ome. “olerng fa display omplaje tn _thyd_tosameh F “2 seleck® roma Bop Cheaomos__ I : Be BS tut tial oe a. | - _____ Selec! needa ged [asl]. Lolumr Alias hy if —Eui=_Deptno As. Dept COR) DeptNo Dept “i> “Table Texte) alias Names #- amn_+this_leve! —We_ame._Grealing.o liaS_nomes on toble, —Name. ~Syntac &- < To! a wie ae = “Alama, Ex 3- De Se sb (6 Dept Syntax to oo Column_+ toble. level aliag Nome 2- Seleck < Gluran Sane [aan Column Alias —Nomet> 3:4 Column Name2> [as] < Column Alias?) h 2:9 > SS as ~ “Imowtment s- Fo wopsasent+ jnoxrcmentol “-Naluee ‘mn "eked et =e Nolue is 4. leet Cad amon Sent 43 a2 —Esd=_Exomple_of idem with d Gee —C Seed 5 ncatamemt) sy tee -—Grcole_toble Testa (ano yy idem} 4 iF —Name_Norrchane: pi Bp as2y i Westng f= ~_TInseot “Teatt Values cA?) ‘ AZ) -- Envy ~——Insew+ Testi values (C*qr) Allo we. $$ © see “Testi C CSNO 5] Namie Jovi values C2, B7) ae anc Emp. Test4dCName) Values (¢@2)~ Allowed “Table. output § s— Sito vet Nemect ee na tg | A zi Q 2. ~-B Gomple OF jdentity « Gith sew defined. values Greate. Jobe “fast oe sie. sent idemfly (102,59. >Tame- Nasri (aooy “Teskng BH “Insert Tests ee —- Allowed! néen+ Test 9 (Noone Vaoluos C6 RB") ~ Aljaced ble cautpar Serpe SNO Name. [ewes A 2. 205 a oe | Note 3 — Tm the above. enc Useac_@m not = ne _Wantde nsea+ Values +> an idemtity Column by_eneplicitly thon wre fell ow the i ee : i “__ope 8- is_c_-defoult mee. oF 4 dam the User Gmn-not insenr+ . Nalues “dp _idemb+y Colum by etplicitly s rs ON 8--VUsert'=@n insert Valles to on i ~—Tdenadily Col mn sl ees =a jae 2 Sab- tdi ‘ns St on nl —heeck Tesh f5n8 lame) Noles | te 7 -- = Allowed,_ ae a -insert Test CSNo2 Named Values C4, ‘DI 4 = -- anaes : : 1 | . 0 | pesados “10. pesfoem Some op S ‘ Sxations TT sein _ operands NolaeS Sq] Senior = 2Su — ae folowing Opemato-s cme. — Ppers | “Gpasigament_o evatow > = a ‘@ pathmadic—Apeaatr 2 — Z. “@ Relokonol Opemcrbor > <, >=, 52) o> oe aed I>, __ oO logical opestotoar => AND; ORsNoT & set opesato-<'s. Unions Union dll, Taster, Pecf >acep te O Special opectoto-e 2 _ peste © pectarorr N eg ative o: fe ake Tee = Notin = behream Hok iby eheeon _ —is_Aull = is_not nul) - Like. 5 Nod: Like. O Assigntacms Opetaite = Ta assign Cr — Noli. fo a Vostdhle. ot to a_athibute lt Set. —Tn-sal_t- j : “Syntax = < Column_Newne.> 2 ASS iganaem+ —Ppeaatea> ¢ value. a gk See s £- Se) Te : aes NosT1a8. InJ/ fete ee : tastes —— a loan, $= SNoalable. Nermne > < ASSigamamt. opecotey I< Ve "But= Declase @ x ink a pant ete Heit tt A pout ote “To pe. rex Jiaa) Sore, : © hathmalic Opera hoor 8 : Mathematical Calculations tia. dito» — _—Substachen ,paulkplicat ong division _-Syptacc $— LES lu ant aoma> < Aessthmolic 0 pecan, Kvoluo”s gt ee y —O_Mete a ues cto display eamployes—— _4 _—Salenies afters_adding 1000- “Select Saloay , Salony +1000 AS Resuit. @ Werke GQ qulsy to 3 display employee, Name.» jobs Sal —F—Omnuat _Salery of — /- the En osee. fr the. table = (Exi- Select Eomo .Job 5 Salosy > Solany ; #8 be AS Ramuck Sciloay Pera feny5 ee —@ histo quem) dou abe. inte Oe Salermy E eat ceufradeeetGt Eats enh Qoxk nae as - - @ = Salory + - Bs Analys¢? LZ rdate. Bap Set Slory Cae ok aeren Whore. = ® pate quency o_updote cll em plowegenan, ~gglonies (2th a_i Cremenk Of By. ae Ge _vpdate.. GnpS Se} Salaay . Salons > Saloay % O85 - Relakonal Opersaten 8 fe a Comporing a specific _Glumn NaJucs sith even USene define} __Onditons. ; Te Syntax t= biherre < Column Name 7 Select eomp _tohence. Hire. date. < _— £198) mig be) oe ee el Haste, a queny _dp inSearde. etudemtbid + -Studente Same. and theme Subject moaks _fin—__— - al, quedago..4_class_of ach Shicleas+——— | = fotna_by Youle. gS ee 2 [\ ® lagical_o JowalerS §- “To Cheak moe thong” ~—one_Gondition in the. qusay-These-———___ ~ ee ND-7 OR) Not 2s AND Operate a= = _ Con D4. Copp 2 Result ih Z = fens ets = a S| LE — =f F fp | fp P _ T22° F | SSR ede 8 ern aie eRe [TR metheeen' “a Valicdi_cab.em [Link] ath. —Pondlibion ocr. he tn that ques | Siena. = éCondlhen a> AND Ltondthion 2 2) ___AND_<.Con dusts an BQ | Eee = § “ —Hatte agony wey 3s tapag ploy en rohit sc One” Wosking— jn tho. Rolie cece a Whas ~__Name_is_* [Word >» ar raermeen * cial sob = ‘ Cleontk?. ste epee aVa)\uc Af Oy One. Gndihes = / Me cuea an mis ype fom gro 4p. Of ordition gy ape tee then 1, OR, te litter 2> oR “aia __Ltend ition 3 > OR ~ | i = = ae [ “site aq]ueory to dt —te_cispl. pa |iS}+ of oe | whoawe oxr)\ Sole ek fear _Emprle = 7343 6R | Bmpno = I566 OR Pmpio> = 7788 _ Not #= Tb: sehremSidll) Vdlee’ _excopt thee _gilem_Condikonal. Values im the. quesy. —— ks “symtaot * = : Whexe. Not = < —AND Not < columname 2 =-S Salas > AND si05- pa eons ane” owing _ons ~—Jebis_cleark, -famolyst: Se Dalat. from “Ero home oy —roB = ‘clean --AND. JoR = ¢ Ana ps2 ice ne © “Special pentahrrs 8 oe 2a |_ Sere ers upports - Ee ed) lowing Spe cialio percctont SORE sad oa = oS Om operator $= Grponing the que 2a Of Najusis based _on_a_six gle ordition In the queny - eet A Syntax Seas! ta pitts aay 7 - Z Where < columa name> Ink list of Values “=e display the Jict+ of “employea Hho —Orre @anking “unde _tha ermplozee Numbers. (~-OrE_-F4695 T5665 3788. ba = Selecl * fom Grp Where. BopNo _ Ch 2 C1964. T5664 5708) : wei dal “ONoT_Imt— Tt _setuems the Ist of ~Nalus's -ectCaph tho given: Gnd iH orabal Cae * Syntace 3 — - = Sen 2 ~—_Whenre_ -Not tr £[ist_of ~_Nalues 2): : Sy iy -s re Ect — Ta _pelete list of employes: form thos il able. tiha-or- nak tombe Toad sho. ~_ Jobs Salesman +.mMaridgen 5 president. -> Delete. flarn_fmp_bhgere. - 3OB_Nop “+ | Ct Salesman?) Momogen ”, * pre Ft sy a - pe etl Bowk. rh om phi [ pwes = ve om | © 4 tahuems— all salle incloding “Selita || _ 4 destinakon Nol\ues Prova the given crange _ © Gn! implimem+_along oth AND )_ opersatox- ae _@©_st_olways_vse_on_low reas To_ High No\ues..— itd rekon: — [ ~ Wisenie!2. cline Petoeen Zlow Valuc> — | AND« hlen Noles, > B= Te display em loyen.: thos emp ene | Solangy. ‘bohadem yaaea a 447,000 -2_Select. # fiom _ Emp _Satee7__blhere._ aalory— _betvieen 10,000 AND 4.000%. 8 Corp) _ 7 _ elech from _Emp_ HhenreCaalloary 7 = athe L—_la noo AND C Sdloary < = 47,008) + Betioeem = C7 = Anp <=) HBS Display - the list. fia tinn "Gt Join_in_the.yeors oF * bheme._tiinenabebelioeim Bl-g\-ol? ¢ ]g8)\- J2-3] * : @ “@QNOT between 3- 7+ seduems all Values _ (-Sot@epk the given ssongeValue—— — Syntax 2-_ |Jheme. < Coluron Nome > Nok __ | — betnemm AND. 4 High Value.>_ Ext To_pigy sha j lish of employee: ihd-ome._ Ate. Ae teaace of IGBjo > ee —not_joine [i Select * fipm. Gro p_bheme.dtimredciie NOT —behoeem_e/98i=ol-0]? AND © J98I=j}2-3)7 [po esestater sae ——Gmgonsng_Nults tno dable. Syntax t= heme _< Column Home. 718 Nul) ees = = anole _ ———Hastec quem te-dieplay- the list of = -Lem plopea-_toh oS CommiSsioy: |S ~See Nulp => Seleck % fiom: Bmp _Mheme.Cornm 1S_Hull ~@_ ss Not Nolen : —— Ne cee. no- mopar La » NUNS jn_a-+table. ° ee | eg A_ Symes. 1- Wheore. < Column Noma jig nob i HL ee ee Helle plenty ee fe Beta Waite _aiqueay do_dis oy tho. ft of -emnploger.- Pho's._ Osmmn} Ssioin «hs p aiey Upeb hud is sissies San ele i | = > Select % foo Emap ‘fiicnasnGarim te pels | ull : ah nits | hosing ith Nuli s= Null is a onknown on undefined Valao. ! LW idlate bose. ee es ee 7 —2>_Null_js wot equel do genn 4 ib not egqucl| to_Space . : te 2 If any dixthmabc_ Operates is_pery wig _ theo ersation ith Null then jt _ogain. a __ mehréms Nul] Only Me jp o+ Null) => Jono + Null —> Null i> a- Null — jooo~ Null — Nult -Ni>_0 Null —> looo %* Null —> Null] —__IN> a J Nl] => Jooo / Null ~? _ fxs- Matte a query to display Smplayon. Samal] 7 job» Sala} Co Mme als ws bang ot 60 M4 fiom 4 — the tables Whois eam ployee. Nemme_aS——_ ——_Srnith_- -- => Select Fmame..job »Salany_»CoMM ySoloay— —towm As tetat from_Emp Nhere. Freme —-=_t Smith? Frame job Saleay Copa fatal 1 smith _cleork 8000 Nu) Nu] ® k _A_fimctio 9 fires! c iS noth bub te aoe? eae dask_ag pene ‘he ghten egies fe must Cetuims_ OValug. . Laseaved Su boeette lly o ‘ip i poatt feoes 1g do a0 E = [— ——_——fimsfioma E spe Fecclons— senda ‘Riealicns || Using pleat i r/. sal). iz paulefined_fimichans 8 Sak Senex. supports t f the_following predefined. fimction_one i 1) Nurmbeat_ftinchions. = Lil) chorracten /s Shing fictions ——— hii) Date. 4. Time. [Link] §— [8 Bagangattue_/ damaping fae a Syntax. £ Saack< ncn sad — a reSS10N) ae | 12 tian. { Bess avi J BWA8s.65/ 82 Te: Haale regalo AO |e im dn positive Sign valle | TT] TT tee. selack ABE. C 12) AS. 5 Regist —— red Ave $= joo — — ~_Eet= Selec ENames + Salary »-Co207-+- -ABS (—~COmm = Soloxy)_As_tesult from —Emp -—AS_aesuld- ——— wuis+ oy De nal, —2) Ceiling #- Te voduens a Peis Cohich _ Ka 16 greatest than the given _eospacssion__ “—Ect=__ Selec} Ceiling C9- 3) Ans #- do ————— Select Cei img C-9: 8) Ans t= -9 OB. 4- Fb aetutms a volua wbich is _ ——leas_than toa given Ox Parc SSioIm i} & &= Select floox cg: 8) Ans 8- J Select —fleos (=9-35 Ans 2— ada Pees s— Th wets a thé given SSL Be 4=_ Select pelea C2185 ANS s—-Q = 6) pied Tk 2xetw’ms pi vali lage _ \Peotee = seleck ples as Bey ct hice B fr _archiems -f eee Sin tone _ Pre Sel eed legC20 7 AS Result A Nyt. sd ge. — - - ——-&__| Apiest. p= cet ne he Ss p28 Hamic Volog. sbas. eto. Ee B= Select- ee dos atar. _AS pesult Ap: ; D- “Thoaacbene Ov Shing faction 3— 3— re Lenofimction += Dh tetuems the. | engin SE given — SEER Sige pais | ps ee iealeok | Len ELLO®) ‘fas t~- Bas 5 ge —Seleck Len_C HEL Come?) ans -8 ——S] So Gumt _ bes = pa iulgob Shams Ted CENome2 fori_finp __ —— LEN CEName 73 _ ». _AScri C8 Th eepemS) @Scii sash On foro. given chowactta:. ¥ bx8-_ Select ASCIL C827) ps Result Ans? =J0_ | cha a: pela —chantcten of be “ASCAITHo. 2 Select CHAR. CIO) AS Result Ans s-1— ih Isuba Tira ng eithen | lef ‘sided fae of-the given. ahing —* epee ie “B= Select LTRIM (eana 2) As @esult Ans = only SAT = = hie 7 aight > "~_Q_RTRIM.CD = Fiimming dhe eer Side, 7 eae of the: 2 SiVEm\ S Rong Cae pression a Bts- Select: Pere CSAT. 22 AS Resutt Y Anse: sont SAT _ mj. Revere 2 f- hq uae les, cherenc: Sle the given: Shin —. ~_Ex8- select p Reverse C*Saz?) Ag | ees rse..C*Saz) DAS Resaly >, Pee— Saleeb Stone. Reverse Cooma.) fon : mm aie eae a Ap REPLSCATEC I= ah sepeo 4 31 VOrn, __ Shin of Characttn's aa nL Sy fe ol Dbmbba- OF se te nL ® testi | [Bt- Selscl. Renta pear Ae | _ Result ee P 1. | ps? Pe SAT wi GAT, “SAT. r SAL» SAT =| t ste stintiars Ae “D_REPLACE C8 To acpla@:an_ existing chamacters with neo choractens_in the _ gven_< Sete Gi ep atiacin i S| | syntax, 3 : ~REpLact_Lishing < old. chor sx Sémets chon's >") fas=_selech weplace.C ¢ pack « 4 puts ta | Be SAL?) AS Result Ans t= Black 4 lies cet 4 ky GoNCAT CI t= aidie ae *moze_than. + do Seton me er fs es Ex3- Select cancad- C+ Good?, *Meaxning. 23 ___ As Result Ans %= Good Meming no spat. rt eT O. cates agi i a atng ating ~4Shomin g- position of thie 2+ length af —— —~LChovr 2 -Bur- Seleck- Sunaking. Cllelome?, At Asi pesuth ae aot ~Ans ¢ om CO. ~ se } _ es : -_A)_GetDate (9 &= Tr pehvems. the Gutiittind. date 4» Hme in fieemation _of the Systema - Bre- Selec} Getpate 4) — — —— Ans? themed Delis + Apres LAS 8) Geb vie Dake ()-2= T+ metutems the Curren _univensal date. 4 -tirne——____ _infiomation » heme. UT C__ Stone: S for popu Co-ordinate, _univeresab —*Tim-e-. + ________ Bet = Select -GETUTCDATE ©) 0) Doleport (2 = Th wetutms the specified ——inkkeval_fiom the givem date. Coc pression xs pia adale CDDs Get. os a be t= Select Patepart CHH. ie fea - 0 be ms ~eetdaiecs) _d) DoleNome.(> + Sash tah She, name. oR: ‘a specified ind —_ginem, “dale. ecepacssion > Peto the aid Ox €) Dateaded cy s— Adding. dhe number te inttavels_¢o the. given olate expression se] B= Select pateadd CDPD» 20 ened Ex e=_ “ee Dateadd Crim, 40,GelDate | 05 L P Datenige, ees aeditems the. mumbles! L of inteaval 8_§ ie ie aes “the. gem Halen = _ Expressions, 7 _ fet- Select | doledifA Con DD. tale - ~08-0275. £ Qolg-68-027), + ‘i veri bas f Ans ?— B65 i] 9 > ae = — ane Exc t- select Sum _C salary). fra Gop __- Ans: ‘Total Sallawy An 5 —€o- i= 7161000 -Sivenn_ gam Of NaluoS Of O_ _@lumn.. > cat te wet Ans t= _#y ate 65 te Gi may. io) 22 Th we rchuensp48 blan/ ~Bul= Lae be ae : Se | go. 2.000 La > Highest _Salocey — mem Minto 2= J+ 4 pokes Min alba -~_Byss seleck pg C-Salarcf-> outing —onigue. valucs for cS pectic ——t Clumn-+ Herre. clis nck koyword i6 Use a ae avoid oo Quoting of: dupttcabe vailas ————— Ba Select Counk Op Ishin ck Ena woo. from —

You might also like