A hacker on a roll may be able to produce–in a period of a few months–something that a small development group (say, 7-8 people) would have a hard time getting together over a year. IBM used to report that certain programmers might be as much as 100 times as productive as other workers, or more. Peter Seebach
desc suppliers;
Name Null Type
-------------- -------- ------------
EMPLOYEE_ID NOT NULL NUMBER(6)
FIRST_NAME VARCHAR2(20)
LAST_NAME NOT NULL VARCHAR2(25)
EMAIL NOT NULL VARCHAR2(25)
PHONE_NUMBER VARCHAR2(20)
HIRE_DATE NOT NULL DATE
JOB_ID NOT NULL VARCHAR2(10)
SALARY NUMBER(8,2)
COMMISSION_PCT NUMBER(2,2)
MANAGER_ID NUMBER(6)
DEPARTMENT_ID NUMBER(4)
Solution
-- select the odd rows using mod funcation
select * from
(select employee_id, first_name, last_name, salary, rownum rn
from hr.employees
order by employee_id)
where mod (rn, 2) <> 0;
-- select the Even Rows using mod funcation
select * from
(select employee_id, first_name, last_name, salary, rownum rn
from hr.employees
order by employee_id)
where mod (rn, 2) = 0;
Comments