CBSE Class 11 Informatics Practices Sql Worksheet

TOPIC: SQL

→ Write SQL commands for the following based on the table LEARNER:

1. To display data of Students whose marks are 68 or 76 or 78.(use the IN operator)

2. To display all rows except those students that have name as ‘Monica’ or ‘Deepali’ or ‘Akshay’.

3. To display data of students in ascending order of their marks.

4. To display details of students in descending order of names.

5. To display all the rows of the table Learner in ascending order of Marks1. But if several students have the same value for Marks1, for them display is in ascending order of names.

6. To displays rows in descending order of marks but if several students have the same value for marks, for them the display is in ascending order of names.

7. To display details of students who have secured marks above 90 in ascending order of names.

8. To add a new row with values given below:

14,'Siddharth','M',NULL

9. To display data of students where marks are not available.

10. To insert data explicitly specified all the column names of the table with values given: ( 13,'Mani','M',97)

11. To insert a row for student with roll number 14 and marks 45.

12. To change the marks of the row with name as 'Monica' to 94.

13. To change the name to "Deepali" and Marks to 90 for the roll no 6.

14. To delete the row with roll number 14.

15. Remove the entire contents of the table.

Please click on below link to download CBSE Class 11 Informatics Practices Sql Worksheet