Sethington
Technical User
I have an app at work that will only allow me to customize the WHERE clause on a SQL statement.
Currently the SQL Statement is hard coded something like this:
SELECT * FROM ERRORS
Is there a way to do a DISTINCT in the WHERE clause that would return the same results as:
SELECT DISTINCT MEMBER_NUMBER FROM ERRORS
Currently the SQL Statement is hard coded something like this:
SELECT * FROM ERRORS
Is there a way to do a DISTINCT in the WHERE clause that would return the same results as:
SELECT DISTINCT MEMBER_NUMBER FROM ERRORS