Check sibling questions

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

Are ads bothering you?


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 - Teacher, Engineer, Marketer

Made by

Davneet Singh

Davneet Singh is a graduate from Indian Institute of Technology, Kanpur. He has been teaching from the past 12 years. He provides courses for Maths and Science at Teachoo.