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
Nov 26, 2020
in
Sql
by
SakshiSharma
How do we use the DISTINCT statement? What is its use of DISTINCT statement?
#sql-distinct
#distinct-statement
#
Please
log in
or
register
to answer this question.
1
Answer
0
votes
answered
Nov 26, 2020
by
rajeshsharma
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
Jul 6, 2020
in
Sql
by
Robindeniel
#sql-distinct-statement
#distinct-statement-sql
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 target designer?
asked
Dec 23, 2020
in
Informatica
by
SakshiSharma
#target-designer
#
0
votes
Q: What is the use of .hiverc file in Hive?
asked
Jan 12, 2020
in
Big Data | Hadoop
by
sharadyadav1986
#
hiverc-file-hive
Bigdata-questions-answers
Hadoop-questions-answers
+1
vote
Q: What do co-workers say about you?
asked
Oct 24, 2019
in
Interview Question
by
AdilsonLima
interview
#interviewquestions
#interviewquestionandanswer
#
0
votes
Q: How to initialize array in java?
asked
Oct 9, 2020
in
JAVA
by
SakshiSharma
#initialize-arrary-in-java
#java-array-initialisation
#
Java-questions-answers
0
votes
Q: How to register new gTLD names?
asked
Oct 5, 2020
in
Web Hosting
by
Robindeniel
#register-gtld-names
#
0
votes
Q: How to become a domain registrar?
asked
Oct 3, 2020
in
Web Hosting
by
Robindeniel
#domain-registrar
#
0
votes
Q: How to reset a password-protected BIOS configuration?
asked
Aug 22, 2020
in
Cyber Security
by
sharadyadav1986
#password-protected-bios-config
#
bios-configuration
0
votes
Q: How long the items in ViewState exists?
asked
May 14, 2019
in
Other
by
Robindeniel
#dotnet
net
#
dot#net
...