Scribd
Upload
6 views1 page

SQL Queries for Student Management

The document contains a series of SQL queries for managing a database of students and fees. It includes various SELECT, INSERT, UPDATE, DELETE, and ALTER statements to retrieve, modify, and structure data. Additionally, it demonstrates creating and dropping tables as well as managing relationships between students and their fees.

Uploaded by

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

SQL Queries for Student Management

The document contains a series of SQL queries for managing a database of students and fees. It includes various SELECT, INSERT, UPDATE, DELETE, and ALTER statements to retrieve, modify, and structure data. Additionally, it demonstrates creating and dropping tables as well as managing relationships between students and their fees.

Uploaded by

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

1.

SELECT Name, City FROM Students WHERE Class = 6


2. SELECT * FROM Students WHERE Marks >= 90
3. SELECT Name FROM Students WHERE City IN ('Mumbai','Chennai')
4. SELECT StudentID, Name FROM Students WHERE Name LIKE '%a%'
5. SELECT * FROM Students WHERE City LIKE '_____'
6. SELECT Month, Amount FROM Fees WHERE Amount < 2500
7. SELECT * FROM Fees WHERE StudentID = 1
8. SELECT [Link], [Link] FROM Students s JOIN Fees f ON [Link] =
[Link] WHERE [Link] = 'April'
9. SELECT Name FROM Students WHERE Marks BETWEEN 80 AND 88
10. SELECT * FROM Students ORDER BY Marks DESC
11. SELECT StudentID, SUM(Amount) FROM Fees GROUP BY StudentID
12. SELECT * FROM Students WHERE StudentID NOT IN (SELECT StudentID FROM
Fees)
13. SELECT * FROM Students WHERE Name LIKE 'K%'
14. SELECT StudentID, Name FROM Students WHERE City <> 'Jaipur'
15. SELECT Marks FROM Students ORDER BY Marks DESC LIMIT 3
16. SELECT * FROM Fees WHERE Month IN ('April','May')
17. SELECT AVG(Marks) FROM Students WHERE Class = 7
18. SELECT [Link], [Link], [Link] FROM Students s JOIN Fees f ON
[Link] = [Link] WHERE [Link] > 2400
19. SELECT [Link], [Link] FROM Students s JOIN Fees f ON [Link] =
[Link]
20. SELECT * FROM Students ORDER BY Marks ASC LIMIT 1

21. INSERT INTO Students VALUES (6,'Rohan',7,'Surat',83)


22. INSERT INTO Fees VALUES (106,5,'July',2600)
23. INSERT INTO Fees VALUES (107,3,'June',2400)
24. UPDATE Students SET Marks = Marks + 3 WHERE Name = 'Riya'`

25. UPDATE Students SET City = 'Bengaluru' WHERE Name = 'Tara'`


26. UPDATE Fees SET Amount = 2350 WHERE StudentID = 2 AND Month = 'April'`
27. UPDATE Students SET Marks = Marks - 2 WHERE Name = 'Aarav'`
28. UPDATE Students SET Class = 8 WHERE Name = 'Kabir'`

29. DELETE FROM Fees WHERE StudentID = 4 AND Month = 'May'`


30. DELETE FROM Students WHERE Marks < 80`
31. DELETE FROM Fees WHERE Month = 'April'`
32. DELETE FROM Students WHERE City = 'Kolkata'`

33. `ALTER TABLE Students ADD Phone VARCHAR(20)`


34. `ALTER TABLE Students MODIFY City VARCHAR(50)`
35. `ALTER TABLE Students DROP COLUMN Marks`
36. `ALTER TABLE Students RENAME TO SchoolStudents`

37. `CREATE TABLE Subjects (SubjectID INT, SubjectName VARCHAR(50))`


38. `CREATE TABLE ClassTeacher (Class INT, TeacherName VARCHAR(50), Phone
VARCHAR(20))`
39. `DROP TABLE Subjects`
40. `CREATE TABLE BackupStudents AS SELECT * FROM Students`

You might also like