Sql in orcal employee table create

**create employee table in sql**

 create table employee (employeeid int,employeeName varchar2(10),departmentName varchar2(10),salary int);

insert into employee values(10101,'srinivas','mechanical',65000);

insert into employee values(10102,'arjun','it',64000);

insert into employee values(10103,'ram','hr',70000);

**Use select operater by where condition**

select*from employee

where employeeid=10102;

**2nd**

select employeename,salary

from employee

where employeeid=10102;

**3rd**

select*from employee

where salary=64000 and departmentname='it'