distinct
Use this command to remove duplicates from the returned results.
Syntax
distinct <field_name> (,<field_name>)*
Parameters
The following table lists the parameters used with this command, along with their descriptions.
Parameter | Description |
---|---|
|
Use this parameter to specify the field name. |
The following query returns the distinct list of entities having ORA-00600
errors.
Message like '%ORA-00600%' | distinct 'Entity Type', Entity