Multiple choice technology databases

The below query can be used to get distinct sal from emp table: select unique sal from emp;

  1. True

  2. False
Reveal answer Fill a bubble to check yourself
A Correct answer
Explanation

The UNIQUE keyword is a valid Oracle SQL synonym for DISTINCT. Both SELECT UNIQUE sal and SELECT DISTINCT sal return each salary value only once, removing duplicates. The query executes successfully and returns distinct salary values from the emp table.

Keep practicing — related questions