student_table
an anonymous user
·
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