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

Popular Posts