Question 4 - Past Year - 1 Mark Questions - Chapter 9 - Structured Query Language

Last updated at July 23, 2026 by

This question asked in CBSE SQP-2020

Which clause is used to remove the duplicating rows of the table?

 

Answer:

The DISTINCT keyword is used to remove the duplicate rows in a table.

Syntax: SELECT DISTINCT column1 , column2, ...

      FROM table_name ;

 

Example:

Question 4 Very short- image 1.jpg

Question 4 Very short- image 2.jpg

Remove Ads

Transcript

This question asked in CBSE SQP-2020 Which clause is used to remove the duplicating rows of the table? Answer: The DISTINCT keyword is used to remove the duplicate rows in a table. Syntax: SELECT DISTINCT column1, column2, ... FROM table_name; Example:

Davneet Singh's photo - Co-founder, Teachoo

Made by

Davneet Singh

Davneet Singh is an IIT Kanpur graduate and has been teaching for 16+ years. At Teachoo, he breaks down Maths, Science and Computer Science into simple steps so students understand concepts deeply and score with confidence.

Many students prefer Teachoo Black for a smooth, ad-free learning experience.