Q. Write SQL commands for the following on the basis of given table STUDENT1.
(a) Select all the Nonmedical stream students from STUDENT1.
(b) List the names of those students who are in class 12 sorted by Stipend.
(c) List all students sorted by AvgMark in descending order.
Answer =
(a)
select * from student1
where stream = “Nonmedical” ;
(b)
select name from student
where class like “12%”
order by stipend ;
(c)
select * from student1
order by AvgMark desc
thanks for the answer
ReplyDeleteWelcome ......
DeleteIt helped me complete my homework on time, Thanks
ReplyDeleteWelcome : ) ^_^
DeleteThanku
ReplyDeleteWelcome : )
DeleteThanks
ReplyDeleteWelcome.
Delete4th?
ReplyDeleteTell me Question.
DeleteCan you tell the ans : List the names that have grade A sorted by stipend.
ReplyDeleteSelect name from student1 where grade = "A" order by stipend ;
Delete4 arrange the record of the class name wise please give me answer
ReplyDeleteSelect name , class from student1 order by name ;
DeleteDisplay all the students whose grade is 'B' and average marks are less than '70%' . Give me answer.
ReplyDeleteSelect* from Student1 wher grade= "B" and AvgMark < 70 ;
DeleteDisplay a report listing Name, Stipend, Stream and amount of stipend received in a year assuming that the Stipend is paid every month
ReplyDeleteSelect Name, Stipend , Stream ,Stipend * 12 as "Stipend per Year" from STUDENT1 ;
DeletePost a Comment
You can help us by Clicking on ads. ^_^
Please do not send spam comment : )