Get distinct values from database using Eloquent ORM

94 0 0 0

Last Updated : 2022-05-23 09:34:57

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

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.