Shen's Blog
Friday, 25 March 2011
Oracle-Find Even records
Find even records
-------------------------
SELECT k FROM (SELECT empno k, MOD (ROWNUM, 2) t FROM emp) WHERE t = 0
No comments:
Post a Comment
Newer Post
Older Post
Home
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment