is There A Laravel PHP Function To Show Database Records Without Duplicates?

Question

I need to be able to bring back records from an sql stored procedure and display them. but I do not want to show duplicates.

I have stored procedure that brings back all records where ID = the selected ID. It then displays something like this

id	value
12	34
12	34
12	33
12	33

question from:https://stackoverflow.com/questions/65884071/is-there-a-laravel-php-function-to-show-database-records-without-duplicates

Answer 1

Yes. To display a single occurrence, you must use "distinct"

$result = DB::table('YourTableName')
->select('id', '//other columns')
->distinct()
->get();