Create student table on orcal by sql
**student table create**
create table student (rollno int,name varchar2(10),age int);
insert into student values(1,'aman',20);
insert into student values(2,'atul',20);
insert into student values(3,'baljeet',20);
insert into student values(4,'harsh',20);
insert into student values(5,'prateek',20);
insert into student values(6,'pratham',20);
**Query**
1st*
select*from student
where age=20 and rollno=4;
2nd*
select name
from student;
Comments
Post a Comment