SQL Lab's

SQL LAB SESSION -1

1. Create a table school with following attributes.

2. Display the structure of the tables School

3. Insert the following rows

4. Insert the following information to School table

5. Add the following 3 attributes to school

6.Modify the width of the attributes Sname to 20 characters

7.Create duplicate table for school with name School_Details

8.Drop the table School

9.Create five different tables for different classes from student_details

10. Update the name of the student with Bindu whose Regno is 109

11. Update the date of join with 16-JAN-99 whose Regno is 110

12. Give Regno as 111 for Jyosna

13. Save the data permanently

14. Delete the records from school_details

15. Get back the details what you have deleted

SQL LAB SESSION -2

1. Display the details of school

2. Display the information about student Rajesh

3. Display the information about students whose Regno between 106 and 109

4. Display the information about students any information is null

5. Display the information about students whose Regno is 108,107 and 110

6. Display the information about students whose name start with ‘K’ or ‘R’

7. Display the information about students who are joined after 12-JAN-99

8. Display the information from school details whose name ends with character ‘h’

9. Display the information from school details whose name contains only 5 characters

10. Display the information school_details who are belongs to VI Class

11. Display the details about Jyosna and Kalyani from School

12. Display the details from school whose total > 300 for which m1 , m2 > 70

13. Display the details from school for class VI OR VII

14. Display the details from school which Doj between 01-jan-98 and 15- mar-99

15. Display the details from school whose class has no values

16. Display the details of about the who’s name contains letter ‘A’

17. Display the student information who’s average marks > 70 %

18. Display failed student information

19. Display the information about student who failed in Physics

20. Display the information about the student who failed in Physics and Chemistry

Happy Learning :)

                          By

                                    ERP Circles Team