Can any help me to fix the below sql query
SELECT DISTINCT ORDER_NUMBER, FLAG FROM TABLE
Below was the result
how to not select the duplicate orders and only print the order which has flag true.
Any inputs are appreciated.