975 0 0 0
Last Updated : 2025-04-28 21:58:03
Get distinct values from database using Eloquent ORM
This snippet will teach you how to get distinct values from database using eloquent
To get distinct values you should use distinct() method like below
$days = Reading::whereNotNull('day')->orderby('id', 'DESC')->distinct()->take(6)->pluck('day');
// whereNotNull('column) used to get not null values
Mahmoud Anwar
Back End Developer with a passion for developing innovative web applications that expedite the efficiency and effectiveness of organizational success. Well-versed in technology and writing code to create systems that are reliable and user-friendly. Also has the proven ability to motivate, educate, and collaborate effectively to build web applications and effectively track changes. Confident communicator, strategic thinker, and innovative creator to develop software that is customized to meet a company’s organizational needs, highlight their core competencies, and further their success.