How to display those employee whose salary is ODD value?

Oracle Apps Interview Questions › Category: SQL › How to display those employee whose salary is ODD value?

0 Vote Up Vote Down

Questions Master asked 9 years ago

How to display those employee whose salary is ODD value?

1 Answers

0 Vote Up Vote Down

Shailender Thallam Staff answered 9 years ago

SELECT * FROM emp WHERE mod(sal,2)=1;