Oct 20 2009 09:21 AM 47635 36 Display Middle Record shameem_chandu How to display middle record in a given table? Bibhudatta Panda Jun 18th, 2019 Suppose I want middle record 5-9 records CodeSELECT * FROM emp WHERE rownum<=9 MINUS SELECT * FROM emp WHERE rownum<5 shreyas varchasvi Oct 15th, 2018 In rownum we cant use >= operator, only < ,< = operator will work. Answer Question Select Best Answer
Oct 20 2009 09:21 AM 47635 36 Display Middle Record shameem_chandu How to display middle record in a given table? Bibhudatta Panda Jun 18th, 2019 Suppose I want middle record 5-9 records CodeSELECT * FROM emp WHERE rownum<=9 MINUS SELECT * FROM emp WHERE rownum<5 shreyas varchasvi Oct 15th, 2018 In rownum we cant use >= operator, only < ,< = operator will work. Answer Question Select Best Answer
Bibhudatta Panda Jun 18th, 2019 Suppose I want middle record 5-9 records CodeSELECT * FROM emp WHERE rownum<=9 MINUS SELECT * FROM emp WHERE rownum<5
