Find the 6 highest amounts in a table in Mysql

[ozchadl]

I wish to find the 6 highest amounts in my Mysql database.
The database name is employment
The table name is jobs
The columns / fields are:
'Job title'
'Company Name'
'Employment dates'
'Pay'

The 'Pay' column / field contains only numbers such as 100

I would like to know the 6 Highest 'Pay' amounts I received.

Thanks for your help

[TheServant]

I think you mean the table is employment?

SELECT JobTitle, Pay FROM employment ORDER BY Pay DESC LIMIT 6

You should look up ORDER BY and LIMIT commands for MySQL. Also, OFFSET might be useful.