Interview Answer

The first 90 percent of the code accounts for the first 90 percent of the development time...The remaining 10 percent of the code accounts for the other 90 percent of the development time. Tom Cargill

Selecting ODD or EVEN rows from a table

January 1, 1970 12:00 am

Comments



Selecting ODD or EVEN rows from a table



												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



Please login to add comments.