How would I use the read data to find Distinct values in the database?
Example of query below, what I cant work out is how to get to add 'DISTINCT' to the query
Example of query below, what I cant work out is how to get to add 'DISTINCT' to the query
SELECT DISTINCT name FROM table
Fields to retrieve:
If that doesn't work for some odd reason, get rid of the brackets.
For more complicated queries you need to separate commas and whatnot with spaces and always include the model. For example:
DISTINCT( model.field ):model.alias
If that doesn't work for some odd reason, get rid of the brackets.
For more complicated queries you need to separate commas and whatnot with spaces and always include the model. For example:
COUNT( DISTINCT if(job.client_id is null , '' , job.client_id) , if(job.client_name is null , '' , job.client_name)):countof.clients
This topic is locked and no more replies can be posted.