School management

pathak_sakshi_ · May 04, 2021 · SQL
-- create a table
CREATE TABLE Attendance (
 Stu_id INTEGER ,
 Date date ,
 status varchar(25),
 Remark varchar(20)
  
);
-- insert some values
INSERT INTO Attendance values(1,'25-10-2020','present','sucessfully passed the exam');
INSERT INTO Attendance values(2,'25-10-2020','present','sucessfully passed the exam');
INSERT INTO Attendance values(3,'25-10-2020','Absent','absent for exam');
INSERT INTO Attendance values(4,'25-10-2020','present','sucessfully passed the exam');
INSERT INTO Attendance values(5,'25-10-2020','present','failed the exam');



-- fetch some value
SELECT * FROM Attendance;

Comments

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