Which SQL clause is used to eliminate duplicate rows from the result set of a database query?
Answer and explanation
Correct answer: B. DISTINCT
- Step 1: The SELECT DISTINCT statement evaluates the selected columns and filters out identical rows. Step 2. It returns only unique tuples in the final output dataset. Answer: DISTINCT. Why not the others: UNIQUE is a schema table constraint; GROUP BY groups rows for aggregate functions; ORDER BY sorts records.
Practise more Computer Systems, Networking and ICT.
Free questions with an explanation for every one, and full timed Bangladesh Civil Service Preliminary Examination mock tests.
More Computer Systems, Networking and ICT questions
- Which internal CPU register holds the memory address of the next machine instruction to be fetched and executed by the processor?
- Which type of computer memory provides the fastest read and write access times directly to the arithmetic logic unit?
- How many distinct memory addresses can be uniquely referenced by a microprocessor with a 32-bit address bus?
- What is the hexadecimal equivalent of the 8-bit binary number 11011010_2?
- Which logic gate outputs a binary 1 if and only if its two binary inputs are unequal (one is 1 and the other is 0)?
- Which two digital logic gates are considered universal gates because any combinational circuit can be constructed solely using either of the…