sql queries

[pradeep singh]

Hi
Please anybody give me the answers of these sql .tell me code
1.How can we get last 2 records from a table?
2.How can i get 3rd record from a table?
3.How can i get first 3 records from a table?

[Jeanne Boyarsky]

Pradeep,
Take a look at this ask tom article on the rownum concept.

[Karthikeyan Ramaswamy]

hi Jeanne , thank you for above post

i referred above link,

select *
from table
where rownum between 1 and 5;

it's working, but i need query like below

select *
from table
where rownum between 2 and 5;

it's not working.

could help me to make that query without using Top-N & Inner Query

----------------------------
[ June 04, 2008: Message edited by: Karthikeyan Ramaswamy ]