Query List
1. Query to display Employee Name, Job, Hire Date, Employee Number; for each employee with the Employee Number appearing first.
Query:
Select Eno, Ename, Job_type, Hire_date from EMPLOYEE;
Output:
2. Query to display unique Jobs from the Employee Table.
Query:
Select DISTINCT Job_type from EMPLOYEE;
Output:
3. Query to display the Employee Name concatenated by a Job separated by a comma.
Query: Select Ename||','|| Job_type from EMPLOYEE;
Output:
4. Query to display all the data from the Employee Table. Separate each Column by a comma and name the said column as THE_OUTPUT.
Query:
Select Eno||','||Ename||','||Job_type||','||Manager||','||Hire_date||','||Dno||','|| Commission||','||Salary AS "THE_OUTPUT" FROM EMPLOYEE;
Output:
5. Query to display the Employee Name and Salary of all the employees earning
more than ₹28500.
Query:
Select Ename, Salary from EMPLOYEE where Salary > 28500 or (Salary + Commission) > 28500;
Output:
