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: