Query using Distinct

I cannot use the key word Distinct when using the Query Browser without causing an exception
(incorrect syntax near the keyword ‘distinct’ ) is there an alternative word to achieve the same result.

This is an outstanding bug with the query browser. However, you can use DISTINCT in queries within your Ignition project without issues. If you want to test queries with DISTINCT in them, you’ll have to use the respective UI tool of your DB for the time being.