How to select odd or even items from a row in SQL?

I need only even or odd items, so I find modulus operation and this doesn't works

SELECT  * FROM table ORDER BY id WHERE MOD (num, 2) = 1 ASC;

Please help me, I'm noob in sql, as I haven't done much in it.

Answers


SELECT * FROM table WHERE MOD (num, 2) = 1 ORDER BY id  ASC;

Will return all of the odd values of num.


for even

 where ([num]% 2) = 0

for odd

 where ([num]% 2) <>0

SELECT * FROM table WHERE MOD(num, 2) = 1 ORDER BY id ASC;

After fetching the final resultSet for the sql server based on where condition then only we can apply any ordering either ASC and DESC.


For even, query:

SELECT 
  * 
FROM 
  table_name 
WHERE 
  MOD(NUM, 2) = 0 
ORDER BY 
  ID ASC;

For odd, query:

SELECT 
  * 
FROM 
  table_name 
WHERE 
  MOD(NUM, 2) != 0 
ORDER BY 
  ID ASC;

Need Your Help

Is there a nice Unix command for dumping the text representation of a binary file?

c++ c unix text binary

I got some binary files containing integers. Is there some nice Unix command, that will allow me to dump it to a terminal without offset information, etc.?