Home » Other » Training & Certification » Please help me
Please help me [message #301319] Wed, 20 February 2008 01:00 Go to next message
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
Re: Please help me [message #301322 is a reply to message #301319] Wed, 20 February 2008 01:09 Go to previous message
Michel Cadot
Messages: 64131
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
As I said for your previous topic 20 minutes ago:
Michel Cadot wrote on Wed, 20 February 2008 07:49
You first need to read and follow OraFAQ Forum Guide.
Correctly repost.

Regards
Michel


[Updated on: Wed, 20 February 2008 01:10]

Report message to a moderator

Previous Topic: copy a database from one database to another
Next Topic: i need one program urgently
Goto Forum:
  


Current Time: Wed Dec 07 12:51:44 CST 2016

Total time taken to generate the page: 0.28772 seconds