I have a table with the following columns: assetnumber, assetdescription, and assetprice. Assetnumber is unique. To find the row with the highest assetprice and include all 3 columns in the result set I would run a query like the following:
select assetnumber, assetdescription, and assetprice from assettable
where assetprice = (select max(assetprice) from asset)
How would I find the row with the 2nd highest price? How about the 3rd, then the 4th .....