| Please help me [message #301319] |
Wed, 20 February 2008 01:00  |
sweethshasi
Messages: 3
Registered: February 2008
|
Junior Member |
|
|
2)Write a select statement to increase the salary of Accounting department by 10%, Sales department by 20% and other departments by 15% who joined before 01st of January 1982. For those who joined after 1st January 1982, the increments are as follows: Accounting – 8%, Sales – 16%, other departments 12%. Salaries should be rounded up to $100.
SL_NO ENAME DNAME SAL EMP_GRADE INC_PERCENT REV_SAL REV_GRADE
1 XXXXXXXXXXXX XXXXXXXXXX 999999 9 99 999999 9
2 XXXXXXXXXXXX XXXXXXXXXX 999999 9 99 999999 9
3 XXXXXXXXXXXX XXXXXXXXXX 999999 9 99 999999 9
4 XXXXXXXXXXXX XXXXXXXXXX 999999 9 99 999999 9
5 XXXXXXXXXXXX XXXXXXXXXX 999999 9 99 999999 9
6 XXXXXXXXXXXX XXXXXXXXXX 999999 9 99 999999 9
7 XXXXXXXXXXXX XXXXXXXXXX 999999 9 99 999999 9
8 XXXXXXXXXXXX XXXXXXXXXX 999999 9 99 999999 9
9 XXXXXXXXXXXX XXXXXXXXXX 999999 9 99 999999 9
10 XXXXXXXXXXXX XXXXXXXXXX 999999 9 99 999999 9
11 XXXXXXXXXXXX XXXXXXXXXX 999999 9 99 999999 9
12 XXXXXXXXXXXX XXXXXXXXXX 999999 9 99 999999 9
13 XXXXXXXXXXXX XXXXXXXXXX 999999 9 99 999999 9
14 XXXXXXXXXXXX XXXXXXXXXX 999999 9 99 999999 9
please use the tables scott.emp,scott.dept,scott.salgrade
i struck the revison grade
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
