Data Mining Lab

This is a tutorial for those who are not familiar with Weka, the data mining package was built at the University of Waikato in New Zealand. Weka is an open source collection of data mining tasks which you can utilize in a number of different ways. It comes with a Graphical User Interface (GUI), but can also be called from your own Java code. You can even write your own batch files for tasks that you need to execute more than once, maybe with slightly different parameters each time.

Nested Queries Experiment

Nested Queries

List the names of the emps who are getting the highest sal dept wise.

List the emps whose sal is equal to the average of max and minimum

List the managers whose sal is more than his employess avg salary.

List the emps who joined in the company on the same date.

List the Managers name who is having max no.of emps working under him.

List those Managers who are getting less than his emps Salary.

Print the details of all the emps who are sub-ordinates to Blake.

List the employee name,Salary and Deptno for each employee who earns a salary greater than the average salary of their department order by Deptno.

List out the Names and Salaries of the emps along with their manager names and salaries for those emps who earn more salary than their Manager.