DBMS- Queries

 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;