Home
Recent Q&A
Java
Cloud
JavaScript
Python
SQL
PHP
HTML
C++
Data Science
DBMS
Devops
Hadoop
Machine Learning
Azure
Blockchain
Devops
Ask a Question
How do we use the DISTINCT statement? What is its use?
Home
Sql
How do we use the DISTINCT statement? What is its use?
0
votes
asked
Jul 6, 2020
in
Sql
by
Robindeniel
How do we use the DISTINCT statement? What is its use?
#sql-distinct-statement
#distinct-statement-sql
Please
log in
or
register
to answer this question.
1
Answer
0
votes
answered
Jul 6, 2020
by
SakshiSharma
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.
Syntax:
SELECT DISTINCT column_name(s)
FROM table_name;
Your comment on this answer:
Email me at this address if a comment is added after mine:
Email me if a comment is added after mine
Privacy: Your email address will only be used for sending these notifications.
Related questions
0
votes
Q: How do we use the DISTINCT statement? What is its use?
asked
Nov 26, 2020
in
Sql
by
SakshiSharma
#sql-distinct
#distinct-statement
#
0
votes
Q: What is DISTINCT statement in SQL server? What is its use?
asked
Apr 22, 2020
in
DBMS
by
Hodge
#sqlserver
#dbms
0
votes
Q: What is the use of Angular filters? What are its distinct types?
asked
Jun 6, 2022
in
Angular
by
john ganales
angular-filters
0
votes
Q: How MySQL Optimizes DISTINCT?
asked
Jan 14
in
Sql
by
AdilsonLima
mysql-interview-questions-answers
0
votes
Q: What do you mean by Stored Procedures in SQL? How do we use it?
asked
Jul 8, 2020
in
Sql
by
Robindeniel
#sql-stored-procedures
#stored-procedures-sql
0
votes
Q: SQL SELECT DISTINCT Statement
asked
Sep 9, 2019
in
Spark Sql
by
ivor2019
#sql
#sql-syntax
#sql-select
#sql-query
#sql-database
#sql-reference
#sql-tutoial
#sql-programming
#sql-intro
#sql-commands
#sql-excesise
#sql-certificate
+1
vote
Q: Why do we use SQL constraints? Which constraints we can use while creating a database in SQL?
asked
Nov 26, 2020
in
Sql
by
SakshiSharma
#sql-constraints
#create-database-sql
+1
vote
Q: Why do we use SQL constraints? Which constraints we can use while creating a database in SQL?
asked
Jul 6, 2020
in
Sql
by
Robindeniel
#sql-constraints
#constraints-sql
#sql-database
0
votes
Q: Why do we use FROM clause with SELECT statement?
asked
Jan 3
in
MariaDB
by
rajeshsharma
select-statement
0
votes
Q: Why do we use import statement?
asked
Nov 29, 2019
in
Machine Learning
by
SakshiSharma
#import-statement
Machine-Learning-questions-answers
...