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

Learn in your speed, with individual attention - Teachoo Maths 1-on-1 Class


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:

Ask a doubt
Davneet Singh's photo - Co-founder, Teachoo

Made by

Davneet Singh

Davneet Singh has done his B.Tech from Indian Institute of Technology, Kanpur. He has been teaching from the past 13 years. He provides courses for Maths, Science, Social Science, Physics, Chemistry, Computer Science at Teachoo.