How would I change the following statement to yieldonly unique values?
select * FROM WEBDBASE where ST = ‘#State#’ AND #SPECIALTY# = ‘x’;
You can’t get unique values when using SELECT *. However, you can specify the DISTINCT keyword immediately before the column name of the column that you’d like to be unique:
SELECT DISTINCT st FROM Webdbase WHERE specialty = ‘x’;