in Sql by

How do we use the DISTINCT statement? What is its use of DISTINCT statement?

1 Answer

0 votes
The DISTINCT statement is used with the SELECT statement. If the record contains duplicate values then the DISTINCT statement is used to select different values among duplicate records.


SELECT DISTINCT column_name(s)

 FROM table_name;

Related questions

+1 vote
asked Oct 24, 2019 in Interview Question by AdilsonLima
0 votes
asked May 14, 2019 in Other by Robindeniel
0 votes
0 votes
asked Dec 16, 2020 in JAVA by SakshiSharma
0 votes
asked Nov 14, 2020 in JAVA by rajeshsharma