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 MySQL Optimizes DISTINCT?
Home
Sql
How MySQL Optimizes DISTINCT?
0
votes
asked
Jan 14
in
Sql
by
AdilsonLima
How MySQL Optimizes DISTINCT?
mysql-interview-questions-answers
Please
log in
or
register
to answer this question.
1
Answer
0
votes
answered
Jan 14
by
AdilsonLima
DISTINCT is converted to a GROUP BY on all columns and it will be combined with ORDER BY clause.
SELECT DISTINCT t1.a FROM t1,t2 where t1.a=t2.a;
Related questions
0
votes
Q: How many TRIGGERS are allowed in MySql table?
asked
Jan 15
in
Sql
by
AdilsonLima
mysql-interview-questions-answers
0
votes
Q: How to display top 50 rows in MYSQL?
asked
Jan 15
in
Sql
by
AdilsonLima
mysql-interview-questions-answers
0
votes
Q: How to enter Characters as HEX Numbers in MySQL?
asked
Jan 15
in
Sql
by
AdilsonLima
mysql-interview-questions-answers
0
votes
Q: How do you login to MySql using Unix shell?
asked
Jan 13
in
Sql
by
DavidAnderson
mysql-interview-questions-answers
0
votes
Q: How to get current MySQL version?
asked
Jan 13
in
Sql
by
DavidAnderson
mysql-interview-questions-answers
0
votes
Q: List all the Access Control of mySQL?
asked
Jan 15
in
Sql
by
AdilsonLima
mysql-interview-questions-answers
0
votes
Q: What are the different tables present in MySQL?
asked
Jan 14
in
Sql
by
AdilsonLima
mysql-interview-questions-answers
0
votes
Q: What are the drivers in MySQL?
asked
Jan 13
in
Sql
by
DavidAnderson
mysql-interview-questions-answers
0
votes
Q: What is REGEXP in MySQL?
asked
Jan 13
in
Sql
by
DavidAnderson
mysql-interview-questions-answers
0
votes
Q: What is the usage of ENUMs in MySQL?
asked
Jan 13
in
Sql
by
DavidAnderson
mysql-interview-questions-answers
...