db2.4.2

Please provide SQL statements, on a separate sheet that answer the following:

  1. Display Oracle database employee last_name and salary for employee_ids between 100 and 102. Include a third column that divides each salary by 1.55 and rounds the result to two decimal places.
  2. Display employee last_name and salary for those employees who work in department 80. Give each of them a raise of 5.33% and truncate the result to two decimal places.
  3. Use a MOD number function to determine whether 38873 is an even number or an odd number.

  4. Use the DUAL table to process the following numbers:

    1. 845.553 - round to one decimal place
    2. 30695.348 - round to two decimal places
    3. 30695.348 - round to -2 decimal places
    4. 2.3454 - truncate the 454 from the decimal place
  5. Divide each employee’s salary by 3. Display only those employees’ last names and salaries who earn a salary that is a multiple of 3.
  6. Divide 34 by 8. Show only the remainder of the division. Name the output as EXAMPLE.

results for ""

    No results matching ""