Answers for "write query for the following: (1) to create a table from a table. (2) to eliminate duplicate rows. (3) to add a new column in the table (4) to sort data in a table"

how to remove duplicate in sql

Distinct: helps to remove all the duplicate
records when retrieving the records from a table.

SELECT DISTINCT FIRST_NAME FROM VISITORS;

Posted by: Guest on January-07-2021

Code answers related to "write query for the following: (1) to create a table from a table. (2) to eliminate duplicate rows. (3) to add a new column in the table (4) to sort data in a table"