1. display all records of data base-
Query-
select * from Chitransh_stu;
2. display the name whose age is lesser than 20-
Query-
SELECT name
FROM Chitransh_stu
WHERE (age < 20);
3. display the marks of students with their names whose section is BCA-
Query-
SELECT name, marks
FROM Chitransh_stu
WHERE (course = 'BCA');
4. Delete a record from the table whose address is jabalpur-
Query-
DELETE FROM Chitransh_stu
WHERE (address = 'jabalpur');
5. Delete the records whose marks are greater than 60-
Query-
DELETE FROM Chitransh_stu
WHERE (marks < 60);
6. Insert a new record in the table-
Query-
INSERT INTO Chitransh_stu
(roll, name, age, course, address, marks)
VALUES (10, 'sidhharth', 34, 'mca', 'jabalpur', 89);
7. Update the course of Students whose marks are greater than 70-
Query-
UPDATE Chitransh_stu
SET course = 'MCA'
WHERE (marks > 70);
8. Update the name of a student whose course is MCA-
Query-
UPDATE Chitransh_stu
SET name = 'Sakshi'
WHERE (course = 'MCA');
9. Delete a record whose age is 20-
Query-
DELETE FROM Chitransh_stu
WHERE (age = 20);
10. Update the roll no of a Student whose name is Adarsh-
Query-
UPDATE Chitransh_stu
SET roll = '1'
WHERE (name='Adarsh');
11. display the records whose sections are MCA AND BCA-
Query-
SELECT * FROM Chitransh_stu
WHERE (course = 'MCA') OR
(course = 'BCA');
12. Display the record order by roll no-
Query-
SELECT roll, name, age, course, address, marks
FROM Chitransh_stu
ORDER BY roll;
Comments
Post a Comment