I have two database tables of employee where employee table maintains EMPNO,ENAME,JOB,MANAGER,HIREDATE,SALARY,COMMISION ,DEPTNO and department table maintais details of DEPTNO,DNAME,LOCATION.
questions are :
1)Display the first four rows of employee table.
2)Display the empno,ename from row 2 to row 5.
3) Display the empno,ename for employee of 2nd row
4) Display details of all even rows.
5)Display each empno and his experience in years.
6) Display details of employees joined between 1981 to 1985.
7)Display details of employees who joined in any month between July and October.
8)Display each empno and his total annual income including commission.
9)Display each empno and his job title with the following decoding. MANAGER-M,CLERK-C,ANALYST-A,SALESMAN-S,PERSIDENT-P.
department table consist of rows like
DEPTNO-10,DNAME-ACCOUNTING,LOCATION-NEWYORK ... I am giving you sample table to get an idea of what actually the table fields consists of . and an example row of employee table is as follows:
also some of commission values for some employee is NULL value.
Sir , i need queries for these questions we have 20 questions and we got 11 queries and we are not getting remaining 9 queries which has mentioned above though we have tired those queries but was not able to get correct one.
So, plz kindly guide us with solutions as soon as possible. Thank you.
April 19, 2010 3:58 PM
April 20, 2010 1:40 AM