Home > SQL > SQL – N rows

SQL – N rows


Fetch starting N rows

DB2

select *
from (select rownumber() over(order by <colName>) as row_num, <colName2>
from
<table name>)
as <alias name>
where row_num < N+1 with ur

Oracle

select *
from (select rowid as row_num, <colName2>
from
<table name>)
as <alias name>
where row_num < N+1

Some DBs has function like Top and limit

Fetch Nth row

DB2

select *
from (select rownumber() over(order by <colName>) as row_num, <colName2>
from
<table name>)
as <alias name>
where row_num = N with ur

Oracle

select *
from (select rowid as row_num, <colName2>
from
<table name>)
as <alias name>
where row_num = N

Fetch Nth to Mth rows

DB2

select *
from (select rownumber() over(order by <colName>) as row_num, <colName2>
from
<table name>)
as <alias name>
where row_num between 1003 and 1118 with ur

Oracle

select *
from (select rowid as row_num, <colName2>
from
<table name>)
as <alias name>
where row_num between 1003 and 1118
Advertisements
Categories: SQL Tags: , ,
  1. No comments yet.
  1. No trackbacks yet.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: