Java with Android Updates
Knowledge Can Impact our Dreams
MY mENU
Home
I-Quest
Code
T-ips
T-Minds
TechWords
Refer
Index
Monday, 16 April 2012
Display Odd/ Even number of records
Odd number of records:
select * from emp where (rowid,1) in (select rowid, mod(rownum,2) from emp);
1
3
5
Even number of records:
select * from emp where (rowid,0) in (select rowid, mod(rownum,2) from emp)
2
4
6
No comments:
Post a Comment
Newer Post
Older Post
Home
No comments:
Post a Comment