Click on the question to see the answer
- How to display 9th record from EMP table?
- HOW TO DISPLAY 5 TO 7 ROWS FROM A TABLE?
- Write a Query to Delete The Repeated Rows from emp table?
- How to Delete the rows of employees who are working in the company for more ?
- How to impose a validation saying that salary cannot be greater 10,000 (note give a name to this constraint)
- How to display those employee whose joining DATE is available in deptno?
- How to display those employee whose joining of month and grade is equal?
- How to display all enames in reverse order? (SMITH:HTIMS)
- How to display the 10th record of emp table(without using rowid) ?
- How to display those employees who joined the company before 15 of the month?
- How to display employee name and his salary whose salary is greater than highest average of department number?
- How to display those employee whose 10% of salary is equal to the year of joining?
- How to display those employee who joined in the company in the month of Dec?
- How to display those employee whose salary is ODD value?
- How to find out last 5 (least) earners of the company.?
- How to display employee name, sal, comm and net pay for those employee whose net pay is greater than or equal to any other employee salary of the company?
- How to display those managers name whose salary is more than average salary of his employee?
- How to display dname where at least 3 are working and display only department name?
- How to find out the top 5 earners of company based on emp dept table?
- How to display all employees name,job,salary,grade and depart name for every one in the company except ‘CLERK’.Sort on salary display the highest salary?
- How to display grade and employees name for the dept no 10 or 30 but grade is not 4 while joined the company before 31-dec-82?
- How to display those employees who are working in the same dept where his manager is work?
- How to display employee name, dept name, salary and comm for those sal in between 2000 to 5000 while location is Chicago?
- How to display the Job groups having total salary greater than the maximum salary for managers?
- How to display the names of the employees who earn highest salary in their respective departments?
- How to display the names of clerks who earn a salary more than the lowest salary of any salesman?
- How to display the employee number and name for employee working as clerk and earning highest salary among clerks?
- How to display name,salary,hra,pf,da,total salary for each employee. The output should be in the order of total salary,hra 15% of salary,da 10% of salary,pf 5% salary,total salary will be(salary+hra+da)-pf?
- How to display the names of employees whose names have second alphabet A in their names?
- How to display the names of the employees who are working in the company for the past 5 years?
- How to display the names of all the employees who are working as clerks and drawing a salary more than 3000?
- How to display the employee name and annual salary for all employees including commission?
Note: New Questions will be added to this list on regular basis