I want to write a sql query to show distinct value in Markdown
I got the value as a table but its duplicate so I want to show the distinct value only!
I try to write
SELECT DISTINCT "Field_name" from "index_name" but I got an error that elastic doesn't support SELECT DISTINCT yet!
SELECT last_value (DISTINCT "Field_name" ) from "index_name" I got an error ( cannot use distinct on non sql function last_value
Thank you for your help
I'm trying what you suggestion and it work
but! I have to order the value by another value field
when I grouped the first field (the field I want it unique ) I can't order by the another field that is not grouped
when I try to group the 2 field and order by wanted field
I got duplicate data again
if you need more explain please tell me