How to database select query with limit in magento 2

Question

I am trying to select records from database table here is query

 $select = $this->newDbConnection()
        ->select()
        ->from($this->getDbPrefix() . 'test', '*')
        ->order('id', 'ASC')

I want to limit result records lets say 500 recoreds per request.

final query would look like this

SELECT `test`.* FROM `test` ORDER BY `id` ASC LIMIT 0,500

How I can set limit**(LIMIT 0,500)** by magento2 way?

Sukumar Gorai · Accepted Answer · 2020-01-31 07:29:20Z

3

You can use the below code:

$select = $this->newDbConnection()
        ->select()
        ->from($this->getDbPrefix() . 'test', '*')
        ->order('id', 'ASC')
        ->limit(500, $offset);

Hope this helps.

Note: Above code is not tested but it should work.

answered Jan 31, 2020 at 7:29

Sukumar Gorai

11k4 gold badges20 silver badges47 bronze badges

Thank you that worked!

Muhammad Ayaz
– Muhammad Ayaz

2020-01-31 08:10:25 +00:00
Commented Jan 31, 2020 at 8:10

Add a comment |

Stack Exchange Network

How to database select query with limit in magento 2

1 Answer 1

Your Answer

Hot Network Questions

How to database select query with limit in magento 2

1 Answer 1

Your Answer

Sign up or log in

Post as a guest

Related

Hot Network Questions