sql query: x max number

can some one tell how to write this query.

from a sorted column how do i pick the some random row( say row no 10)

thanks

--== Sent via Deja.com http://www.deja.com/ ==-- ---Share what you know. Learn what you don't.--- Received on Thu May 13 1999 - 13:58:20 CDT