CBSE eBooks CBSE Guess > eBooks > Class XII > Computer Science By . Mr. MRK
Chapter – 8 . STRUCTURED QUERY LANGUAGE Delhi (2007) TABLE : SENDER
TABLE : RECIPIENT
(i) To display the names of all senders from Mumbai. Ans. Select * from Sender where SenderCity =’Mumbai’; (ii) To display the recID, senderName, senderAddress, RecName, RecAddress for every recipt Ans. Select recID, SenderName, SenderAddress, RecName, RecAddress from Sender, Recipient where Sender.Senderid=Recipient.RenderId; (iii) To display the sender details in ascending order of SenderName. Ans. Select * from Sender order by SenderName; (iv) To display number of Recipients from each city. Ans. Select RecCity,Count(*) from Recipient group by RecCity; (v) SELECT DISTINCT SenderCity FROM Sender; Ans. senderCity New Delhi Mumbai (vi) SELECT A.SenderName A, B.RecName FROM Sender A, Recipient B WHERE A.SenderID=B. SenderID AND B.RecCity=’Mumbai’; Ans. SenderName RecName R.Jain H.Singh S.Jha P.K.Swamy (vii) SELECT RecName,RecAddress FROM Recipient WHERE RecCity Not IN (‘Mumbai’, Kolkata’); Ans.
(viii) SELECT RecID, RecName FROM Recipient WHERE SenderID = ‘MU02’ OR SenderID = ‘ND50’; Ans.
|