[SQL] restircting rows

[padmanabha konkodi]

 
 
hi all,

my query return 100 rows but if i am intrested only from 40-60 rows then how to restrict.

for example

select * from students (returns 100 rows).but i am intrested only rows from 40 to 60.