Home » SQL & PL/SQL » SQL & PL/SQL » i want 100 th record ..
i want 100 th record .. [message #220335] Tue, 20 February 2007 05:50 Go to next message
akkumar81
Messages: 144
Registered: February 2007
Location: india
Senior Member

--------------------------------------------------------------------------------

Hi,

I want every 100 th record in total of 1000 recors in a table.

pls send query.

Thks,
Kiss07
Re: i want 100 th record .. [message #220342 is a reply to message #220335] Tue, 20 February 2007 05:53 Go to previous messageGo to next message
ebrian
Messages: 2794
Registered: April 2006
Senior Member
Check here.
Re: i want 100 th record .. [message #220772 is a reply to message #220335] Thu, 22 February 2007 00:58 Go to previous messageGo to next message
pavuluri
Messages: 247
Registered: January 2007
Senior Member
select empno from ( select empno, mod(rownum,100) rn from emp e) where rn=0

Thnaks,
srinivas
Re: i want 100 th record .. [message #220825 is a reply to message #220772] Thu, 22 February 2007 05:06 Go to previous message
Maaher
Messages: 7062
Registered: December 2001
Senior Member
Closed.

http://www.orafaq.com/forum/fa/448/0/

MHE
Previous Topic: how to get the time in a perticular time zone
Next Topic: nb of records
Goto Forum:
  


Current Time: Thu Dec 08 16:22:03 CST 2016

Total time taken to generate the page: 0.09479 seconds