🔥 Weekly thread #30 of 2022

This week's news and tips for Laravel developers include:

🍺 Laravel Pint v1.1 🚀 Deployer v7 is out 🆕 Laravel 9.22 released 💫 New updates in Spark Stripe 📘 Codecourse and Laracast series

and more...

Thread #131

You can use WITH TIES instead of LIMIT to return more results if they have the same value

2

🔥 You can use WITH TIES instead of LIMIT to return more results if they have the same value

You can use WITH TIES instead of LIMIT to return more results if they have the same value

⚡️ Database Tip

Everyone knows the LIMIT clause. But what do you do if you want to have e.g. the employees with the TOP 3 salaries and not exclude the 4th or 5th one earning the same as the 3rd? The WITH TIES clause can return more results if the value is the same. Great!

We're writing a book, you can get it for free here.