student_table

an anonymous user · March 19, 2023
create table student(
    student_id integer, name varchar(20), subject varchar(15), marks integer, grade char
);
insert into student
values 
(1001 , 'niraj', 'maths', 95, 'A'),
(1002, 'rahul', 'physics', 90, 'A'),
    (1003, 'mukesh', 'polity', 59, 'C'),
    (1004, 'RAMESH', 'chemistry', 85, 'B'),
    (1005, 'sonu', 'maths', 99, 'A+');
    select marks from student where student_id = 1004;
    select name from student where marks = 59;
update student 
set name = 'anjali' where student_id = 1001;
    select *from student;
    delete from student where name  = 'mukesh';
    select *from student;
    
Output
(Run the program to view its output)

Comments

Please sign up or log in to contribute to the discussion.