an anonymous user · January 15, 2022 · SQL
-- create a table
CREATE TABLE studentinfo(
roll int(3),
name varchar(20),
city varchar2(20),
per float
-- alter table
ALTER TABLE studentinfo
add class int
-- desc studentinfo
insert into studentinfo
update studentinfo
set per=91 where roll=2;
select * from studentinfo;
select * from studentinfo
order by per asc;
select sum (per) "total per"
from studentinfo;
delete from studentinfo;


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