Devart Forums

Code: Select all

  CREATE TABLE "EMPLOYEES" (
    "EMPLOYEEID"  NUMBER  NOT NULL
    ,...
    ,"AVAILABLEREGULARDAYS"  NUMBER  NOT NULL
  )

Code: Select all

  SELECT EmployeeId, AvailableRegularDays 
  FROM Employees 
  WHERE IsEligible = 'Y'
  ORDER BY SeniorityNumber

Code: Select all

  24    30
  80    30
  1     30
  2     30

Code: Select all

  24    0
  80    866
  1     816
  2     741