Can any one help me regarding the following SQL QUERY?

I am looking for an SQL QUERY with paging.
I mean to say, the functionality of the sql query may be as per requirement, but finally before ending sqlquery I want to provide paging concept. Either I can send the no of records per page as variable from Front-end or for the time being Let us hardcode the no of records to be displayed per page as 10.