Hello, im building a custom view and i need to add a disctinc value from a custom field.

I have created a module with this:

function mymodule_views_pre_ejecute(&$view) {

here i should add the disctinc

}

how does it work?, i need to a for example SELECT DISCTINC (field.id)

any help?