GeekInterview.com
  I am new, Sign me up!
 
GeekInterview.com  >  Interview Questions  >  Oracle
Go To First  |  Previous Question  |  Next Question 
 Oracle  |  Question 26 of 81    Print  
Write a query to display all the odd numbers from a table

  
Total Answers and Comments: 3 Last Update: June 01, 2007     Asked by: Sudhir 
  
 Sponsored Links

 
 Best Rated Answer

No best answer available. Please pick the good answer available or submit your answer.
June 24, 2006 07:48:59   #1  
Sajid Ansari        

RE: Write a query to display all the odd numbers from ...

SELECT DECODE(MOD(column_name 2) 1 1)

FROM table_name

WHERE DECODE(MOD(PTR_ID 2) 1 1) 1


 
Is this answer useful? Yes | No
July 24, 2006 02:45:22   #2  
jack        

RE: Write a query to display all the odd numbers from ...

SELECT DECODE(MOD(column_name 2) 1 column_name) odd_Numbers

FROM table_name

WHERE DECODE(MOD(PTR_ID 2) 1 1) 1


 
Is this answer useful? Yes | No
June 01, 2007 00:29:02   #3  
Ratheesh        

RE: Write a query to display all the odd numbers from ...

select <column_name> from <table_name> where mod(<column_name> 2)<>0

 
Is this answer useful? Yes | No


 
Go To Top


 Sponsored Links

 
About Us -  Privacy Policy -  Terms and Conditions -  Contact -  Ask Question -  Propose Category -  Site Updates 

Copyright © 2005 - 2009 GeekInterview.com. All Rights Reserved

Page copy protected against web site content infringement by Copyscape