0% found this document useful (0 votes)
14 views4 pages

SQL 1 Question

Learn about sql from basic to advance

Uploaded by

goyiyew212
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
0% found this document useful (0 votes)
14 views4 pages

SQL 1 Question

Learn about sql from basic to advance

Uploaded by

goyiyew212
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
Taba — Date .... Tobu fupm data base - Embloyce: — gd us a €ID | Ename | City Salasuy 100 Smeth Bangiose 1ee-o-o oom Cant Leansor 120008 Jor Ram Chennai 12000 fos Fanke; | bydesa cro oak | rey | Vikasam | Pune BoDo ey > Give me the OG. Read the Embwyce name whose satay 24 10000° Gove the Salauy whose 2%: & Empeyee name) whese & &% S000 and 266 = f0000 ~ Geve_ me the the Empioyee Id whose CGname & Smith ancl Carts: 2 Give me the Employee Iod'th Sonted Se 5 bout the Empwyee Ename abCencling é 3 Set Ge Empeye e In butt fenchinn in BY: os st Give the marm Ld kn degen fecom the table: J # Give min” 2 ret0om the tobe: # Greve He mt 2 fxom tin the ab Ce: # Give Suan of ee the Salanies: Be ee hae oe pany: Buz Count the Aiumbex of. Employee céty wese tt Saree & mployce Based onhes and paint the Count oy Seeraé epee the city after Cosnting hone te ty name £5 a laa 4H Conveut otf He Lanployee names in Cppercase # Yiveme Cop 2 vecoods tn the sabes G # Sout the swcoud Based onthe fables: # qe the ae fest 0ecoud from the tobe: ad fice oe G@st_tvo waco ferom the 1066: se pire me fuse thuse Colter fuon Bobien Empayee tab Cer He peint Cusment sytem time using SOL ] d a H In the tutput, Change the Columntname +o name ak fesint output H Give the empleyee name end wich empaayee wit Eben: te Select Ename ferom Employee wheue Ename Uke "fm 7") HB Select Ename from Empoyce Whee € name Uke " Sy") F__nameyt Gitve the, 6m ployee that Biante wih eten ‘s' i Greve the name of Employce ee with Consist of 3Gbtecg. H aitve the Emplayee Name ett lonsist of S Ublees. HH @ive the Employee Name att, that ends wc yy (elf ee m aol Conese of 8 lobterrs Cnluckéng m:. g HAH delete aucowrd faom. Em bloyce fable wheng Em poo, yee Lol - "to,"; @ HE (Lelete tee 2 Gord fom Emh Goyer pate where Soap ye e Zot su Tonane psyl 4 = Date . a @Q# Hteletea aocoucd furme fable where Sm pioyee nam ets = "Smt "9 we + He bestinee Salauy fuom the fobe- Ht lConcat Emplogee nam e a-a sate? ad point" fe Selert Contat Employee Qal & with — (Undusiore) aud "He Cnet the f@ontent of- these Colrmnn - #f Cemove. the white Spee ferom the Loft Sect of Employee. aot Ename: tt Remove the white Spaces wn the ight Fike of Em pleye ¢ name aud fesint 2 VS oT S| eal ec oe pee tle eg 4 Remove he white spaces fun Left and 244Gb & Biche of Employee nam es aut pusint Hee outputs # Remove fe udhete Shacex fom érame Gof Sater l fem, Soft oxncf eiphé Sicle Qid then Concat them Sepunter site): H uphare eveuyone ara? ie # Mapa Fetes 9 fe tord Wh eng Empteye © name %3 &miy to abc # update fu cilyname 84ngore sity Ban & T ee rarerS pt Hf debote 2 fetord fiom fer fable tohene even uu Lend Employee gnczty vi Sperat #_Deturase the everyone et Oa J # Cont Ename ard Sa Gnd _peint tes out put L oxdue. len cles Conch g enke Atay fee Gselumn End of Ketable Email” H 4dd the @laumn inthe quae of the deb Email = aad Re Column: Email after Ename Column: = Gk t 2 G&S Glamn email from Fa 426 = delete Tre Colony uti He name €-name = ore Faz Ong ef Fath wel eveuy Employee name tr tes fob. find tee length of xe gtuing mraeaaré kas

You might also like