Level 88
Have you actually tried the query?
Feb 27, 2018
10
Level 4
writting distinct query example
i need show the unique values for whole table i have searched in google the query written was
DB::table('products')->select('color')->distinct()->get();
the above query displays the unique color value
how to query for whole table (correct me if i am wrong)
DB::table(products')->select('*')->distinct()->get();
Level 4
@bobbybouwmann i have tried with below query it displays the unique value of colors
DB::table('products')->select('color')->distinct()->get();
other query like below won't displays the unique value
DB::table('products')->select('*')->distinct()->get();
Level 88
Probably because you don't specify which column should be unique here. I think Laravel doesn't support this and you need to write a raw query for it!
Level 4
@bobbybouwmann that's fine sir thank you.can you give me a example of writting raw query of it.??
Level 4
@bobbybouwmann they have given query for distinct it won't displays the unique results. https://laravel.com/docs/5.6/queries#selects
Level 88
Like I said, you need a raw query!
Level 4
@bobbybouwmann not getting to write raw query using above link!! there is no example for using distinct clause!!
Level 88
Well distinct in a sql keyword. You should write a normal SQL query and perform that on your database
Level 4
@bobbybouwmann thank you!!
Please or to participate in this conversation.