CREATE TABLE Stud_Details( AdmnNo integer(4), RollNo integer(2), Name varchar(20), Percentage decimal(5,2) );
INSERT INTO Stud_Details VALUES(1045, 1, 'Ankita', 98.98);
INSERT INTO Stud_Details VALUES(1234, 5, 'Nikita', 100.00);  
INSERT INTO Stud_Details VALUES(2345, 7, 'Pankita', 86.99);
INSERT INTO Stud_Details VALUES(4655, 8, 'Ramya', 99.89);
-- SELECT * FROM Stud_Details ;
-- SELECT Percentage-Percentage*10/100 FROM Stud_Details ;
-- To Edit a cell value or a record (edit Pankita's % to 96.99 )
UPDATE Stud_Details 
SET Percentage = 96.99 
WHERE AdmnNo = 2345;
-- SELECT * FROM Stud_Details ;
-- Edit the record of roll no 5 with data - AdmnNo=1221 & Name = Nayana
UPDATE Stud_Details
SET AdmnNo = 1221 
WHERE RollNo = 5;

UPDATE Stud_Details
SET Name = 'Nayana'
WHERE RollNo = 5;

SELECT * FROM Stud_Details;
-- Edit the record of roll no 5 with data - AdmnNo=1221  
-- Delete a particular record (insert a new record and then delete that )
-- DELETE FROM Stud_Details WHERE 
-- ALTER TABLE Stud_Details ADD HOUSE VARCHAR(10);
-- SELECT * FROM Stud_Details ;