ICP7

ICP7

CASSANDRA

Creating Key Space:

CREATING TABLE:

CREATING TABLE employees1:

INSERTING DATA FROM External file:

QUERY1:

List the empID,ename,jobtitle,and hiredate of employee from the employee table.

QUERY2:

List the name,salary of the employees who are clerks

QUERY3:

List the name,job,salary of every employee joined on ‘february18,2000’

QUERY4:

List name and annual salary of all the employees.

QUERY5:

Display employees’ names, salary and manager values of those employees whose salary is 45000