eg:

select top2 *  from tablename
this table retrive only second row only

from 2nd row if u want only number and name

then like this we have to write
eg:
select top2 empno,ename from emp

Here you go,

  for example , consider one EPmloyee table , to get a 2nd 
row :

 General syntax :
  
   Select < fields names > from <table name > where rownum 
= <row ID>

 Ex : select Ename , Eid , Designation from Employee where 
rownum=2

Select < fields names > from <table name > Limit 1,1