Scribd
Upload
6 views1 page

DML SQL Operations and Solutions

The document outlines a series of DML SQL problems that involve various operations on a Students table and other related tables. It includes tasks such as inserting, selecting, updating, and deleting records, as well as handling duplicates and performing calculations. Each problem focuses on different aspects of SQL data manipulation to manage student and order data effectively.

Uploaded by

shrishail.ad24
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd
6 views1 page

DML SQL Operations and Solutions

The document outlines a series of DML SQL problems that involve various operations on a Students table and other related tables. It includes tasks such as inserting, selecting, updating, and deleting records, as well as handling duplicates and performing calculations. Each problem focuses on different aspects of SQL data manipulation to manage student and order data effectively.

Uploaded by

shrishail.ad24
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd

DML SQL Problems

1. Insert a new student into Students table.

2. Insert multiple rows into Students table.

3. Select all rows from Students.

4. Select specific columns (name, marks).

5. Delete students living in Mumbai.

6. Update marks of Rahul to 95.

7. Increase all marks by 5.

8. Delete student with lowest marks.

9. Select students with marks > 80 sorted DESC.

10. Insert row with NULL values.

11. Copy data to TopStudents table using SELECT.

12. Update Orders table using JOIN with Customers.

13. Delete students below average marks.

14. Select 2nd highest marks.

15. Insert row only if it does not already exist.

16. Find duplicate rows using GROUP BY.

17. Delete duplicates keeping only one.

18. Update salary below department average.

19. Insert computed values (quantity * price).

20. Delete orders whose customer does not exist.

You might also like