demo

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
values(1,'rasika','nashik',90.2,12),
(2,'tanvi','hydrabad',91,12),
(3,'sam','pune',89,12);
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;

Comments

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