Member Avatar for Venom Rush

As the title says, I'd like to select a certain number of rows from a table starting from a specified row.

So for example, I have a table with 250 rows and the rows are numbered incrementally using a column called 'ref'. I now want to select rows 51-100. How would I go about doing that?

  • 1 Contributor
  • 1 Reply
  • 91 Views
  • 6 Hours Discussion Span
  • Latest Post Latest Post by Venom Rush
Member Avatar for Venom Rush

I solved my problem by using the following:

WHERE ref BETWEEN 1 AND 50
Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.