CODEWITHSUNDEEP
mysql
kmdhrm
kmdhrm

Reputation: 535

How to SELECT last 50 entries except latest 5 from a table?

I have a table with around 1000 entries.

I want to SELECT the latest 50 of these entries except the most recent 5 ones. I know how to do this using nested query, but is there a simple way or some special keyword to do something like this.

Upvotes: 0

Views: 65

Answers (1)

juergen d
juergen d

Reputation: 204766

select * from your_table
order by some_column desc
limit 5, 45

Upvotes: 5

Related Questions