0 ratings0% found this document useful (0 votes) 31 views4 pagesDBMS Assignment 2
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
SL Rethiove tome, def of all faculdlts
Sl” SELEC ae
SIP SELECT frame , cla} FROM tasubhy attail 9
Qo Find att employer having Sollany yori
~ than 10000
Sil” = SELecT + FROM Frauudty- depeil WHERE
Salary 210000 5
3. Find. sol number » CoMMse of Student of
having class 2:Se II!
Sol” SELECT HolLna, course
WHERE clags= * BSc III’ 5
FRom studut
. Find enam omphoyse anhese Acsignadion
a, oR oe Jy Jess nan 10000
Sol? SELECT ename FROM -facubty- detail WHERE
C designation = “chink? ond “Salany <1p000 15
realme » Fund nom
ae a Oh oll Studia draving, Course
“ Sa Oma
>
a Shee FROM studsut WHERE
= "B-Se" ORDER BY name ABC +
Qe. Finds emome and dusignation of alt emplegees
in escending, ome Op Sak
Sol” SELECT ename , designation FRom frcully-aatoat
ORDER BY saleny DESC 5
| Be. Find, prome ob focally whee salary
between 10000 amd 20000
Sol” SELECT frame FROM +acukty-dddail WHERE
platy BETWEEN Ip000 AND 20000 5
Qs. Add column, Chay in STUDENT table ond
Grau details
ga” ALTER TABLE
RT INTO student Cid» nome y monks , Ciby
qua , ‘Indes ) 5
shadant APD Cehy varchor2 Go),
INsE! ) VALUES
C3, sanskow "+
realme Qa Find ott stucterchs ree
Bhepals Deus who ore iving sh Bndoesy
sat” ae * Prom wens, eon
| Indore! > Wy
netone ©)" Bhepad', © Duoas ' D5
Gio Deleke Mu detail, of faukty whose tis
lol
Sol” DELETE FRom faculby. Atkail- WHERE LO-
Jol5
Ae Coucde tale = “Book? with jotioving-
og 2 o. ote,
Chia» bename , author » pede» publication >
ond mike bid ax primary kug
Book Ch-id number. C4) PRIMARY
Sol” CREATE TABLE
key, brame vorchar2.¢20) » oudlror varchar 20S) »
pwticetion vorchan2€20) 5
Qn, Creche Robhe AUTHOR-DETAILS with 4otiowing.
oni bes
Cafdy anames prladication + Bmome ) no-¢4-beoks )
ona make — 0-O}- books is NOT NULL
gl” CREATE TABLE AVTHOR-DETATLS Ca-id numbertu),
arame vorcharr0o, publication char C15) 1 Bono
youthan? C10) , No-of- books NunporcS) NT NULL )5
hot by Sanskar Narwaria Qa. Witte quay te
r ae Boros
oe a a 7
| SoI” SELECT
Qa, Rebiewe Distinct value of Brome yor
Rooke AUTHOR
Sol” SELECT DISTINCT CR mame) PROM AUTHOR;
(Qi, Retdent atl Anforunation 4m atudeds
tobi, whire chy us nat (Tnelone J
SELECT * FROM studsnk WHERE
C Nor city = "Indo ) 5
“ ct & FROM gtudank wHere Leahy <> indus a
Seve
Sol”
realme
