How to display middle record in a given table?

Bibhudatta Panda

• Jun 18th, 2019

Suppose I want middle record 5-9 records

Code
SELECT * 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

Dheeraj Singh

• Sep 16th, 2018

You can try this one.I think this query can work..

Select * from tbl_regex Where REGEXP_LIKE(ENAME,^0123456789);

Note:- tbl_regex is table name and ENAME is column name that contain numeric and string type data.

Asish

• Jan 7th, 2018

Here the where clause will be either

Lower(fn) = upper(fn)

Or

Regexp_like(fn, ^[0-9]*$)

Answer Question  Select Best Answer

VIJAI VEDHA

• Sep 28th, 2022

ITS syn NOT sys,

SuryaRS

 Profile Answers by SuryaRS Questions by SuryaRS

• Aug 29th, 2017

TAB will give tables, views whereas CAT will give tables, views, sequences. TAB is having clustered column.

Code
SELECT * FROM TAB
SELECT * FROM CAT

Answer Question  Select Best Answer