Link to home
Start Free TrialLog in
Avatar of brihol44
brihol44

asked on

How do I select all records except the first 5 records with the highest rank number

I have 4 fields in my table (picture_contests).

1. record_ID
2. rank
3. picture_file
4. title

I would like to pull all records except the first 5 records that are ranked the highest.  The rank value is out of a 100 with 100 being the highest.

Thanks,

Brian

ASKER CERTIFIED SOLUTION
Avatar of Dale Burrell
Dale Burrell
Flag of New Zealand image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial