sql query [message #20337] |
Wed, 15 May 2002 00:58 |
madan keshri
Messages: 2 Registered: May 2002
|
Junior Member |
|
|
Dear All,
Could you please send me sql query which result odd or even numbers.
Thanks
Regards
Madan Keshri
|
|
|
Re: sql query [message #20342 is a reply to message #20337] |
Wed, 15 May 2002 05:39 |
andrew again
Messages: 2577 Registered: March 2000
|
Senior Member |
|
|
-- odd
select object_id from user_objects
where mod(object_id, 2) = 1
and rownum < 5
OBJECT_ID
---------------------------------------
44027
44077
44029
44031
4 rows selected
-- even
select object_id from user_objects
where mod(object_id, 2) = 0
and rownum < 5
OBJECT_ID
---------------------------------------
44026
44028
44076
44030
4 rows selected
|
|
|
Re: sql query [message #20361 is a reply to message #20337] |
Thu, 16 May 2002 09:39 |
sridhar
Messages: 119 Registered: December 2001
|
Senior Member |
|
|
I would use ROWNUM for this,
-- To get ODD numbers
SELECT rn + 1 FROM
(Select rownum rn from table_name
Where rownum <= 10)
WHERE mod(rn, 2) = 0;
-- To get EVEN numbers
SELECT rn FROM
(Select rownum rn from table_name
Where rownum <= 10)
WHERE mod(rn, 2) = 0;
P.S You could use any table in your schema, but make sure that it has enough number of rows in there as per your Where condition(Where rownum <= 10). In this case you should have atleast 10 rows to see the results correctly.
Thx,
SriDHAR
|
|
|