taaznyonker

 Profile Answers by taaznyonker 

• Mar 31st, 2010

 

BELOW example will give the middle row of the table(not sorted).

eg:

SELECT * FROM EMP WHERE ROWNUM <=(SELECT COUNT(1)/2 FROM EMP)
MINUS
SELECT * FROM EMP WHERE ROWNUM <(SELECT COUNT(1)/2 FROM EMP)

taaznyonker

 Profile Answers by taaznyonker 

• Mar 31st, 2010

 

Below query will help you

SELECT * FROM EMP WHERE ROWNUM <=(SELECT COUNT(1)/2 FROM EMP)
MINUS
SELECT * FROM EMP WHERE ROWNUM <=(SELECT COUNT(1)/2 FROM EMP)

• Aug 11th, 2011

 

The following query works as follows: If the table has ten records, it will display the 5th and 6th record and if it has some 11 records, will display 6th record alone.

Code
 

sampra

 Profile Answers by sampra 

• Mar 6th, 2012

 

SELECT * FROM EMP WHERE ROWNUM <=(SELECT COUNT(1)/2 FROM EMP)
MINUS
SELECT * FROM EMP WHERE ROWNUM >=(SELECT COUNT(1)/2 FROM EMP)

Nazeera Jaffar

• Sep 26th, 2012

 

The below code returns the rows from 50-74

Code
 

Nazeera Jaffar

• Sep 26th, 2012

 

The below code selects the exact middle row from the table

Code
 

Kishore Kishore

 Profile Answers by Kishore Kishore 

• Mar 10th, 2015

 

Code
 

Naveen Hokrana

• Feb 2nd, 2016

 

Code
 

Shivam

• Feb 13th, 2016

 

WRONG You cannot put = in rownum

sumanamara2016

 Profile Answers by sumanamara2016 

• Mar 18th, 2016

 

It will not work
SELECT * FROM EMP WHERE rownum=trunc(SELECT count(*)/2 FROM EMP)
Error at Command Line : 42 Column : 38
Error report -
SQL Error: ORA-00936: missing expression
00936. 00000 - "missing expression"
*Cause:
*Action:

Code
span style="color: #ff0000;">"missing expression"

Visal

• Aug 13th, 2016

 

Code
 

Kaushik

• Aug 7th, 2017

 

Code
 

SuryaRS

 Profile Answers by SuryaRS 

• Sep 11th, 2017

 

Below code works to have middle record of atable

Code
 

SATHIS KUMAR

• Jan 23rd, 2018

 

SELECT * FROM (SELECT ROWNUM ID,E.* FROM EMP E) WHERE ID IN (SELECT COUNT(*) FROM EMP)

Code
 

mahesh

• Feb 8th, 2018

 

>= is not working in rownum
check it once

Manthan

• Aug 21st, 2018

 

Its displaying:
ERROR at line 1:
ORA-00936: missing expression

shreyas varchasvi

• Oct 15th, 2018

 

in rownum we cant use >= operator, only < ,< = operator will work.

Bibhudatta Panda

• Jun 18th, 2019

 

Suppose I want middle record 5-9 records

Code