How query and to display n-1 rows from a table.

Kindly give me query and also the method

dbtester