Select distinct column 1, column 2 from table name ; and select column 1, column 2 from tablename; | Sololearn: Learn to code for FREE!
- 1

Select distinct column 1, column 2 from table name ; and select column 1, column 2 from tablename;

what's the difference in between both the query .

4th Feb 2017, 3:51 PM
shiva rai
shiva rai - avatar
2 ответов
0
In the first case, results will be filtered for unique column1 and column2 values from the table. whereas the later one, will result all the values from the table. we can have duplicates in the later one.
4th Feb 2017, 7:46 PM
mahendra k
mahendra k - avatar
0
Of column one would always be distinct if it was the primary key
5th Feb 2017, 3:13 PM
Dave Shaul
Dave Shaul - avatar