#30|| Distinct Clause in SQL || SQL LECTURE FOR BEGINNERS ||
Complete SQL Notes Link
https://codingmoments.stores.instamoj...
instagram:- @youtube.coding.moments
Software Link ------
https://drive.google.com/folderview?i...
BLOG: https://codingmoments.blogspot.com/
DISTINCT keyword in Oracle database separates or filters the duplicate rows in the result set returned by the SELECT statement (result set contains the column/columns present in the SELECT statement) so that the column or columns returned by the query contains all the values or records which are not duplicate and are unique to each other as the DISTINCT keyword compares each value of the column/columns present in the result set returned by the query with each other.
SELECT DISTINCT returns only distinct (different) values.
SELECT DISTINCT eliminates duplicate records from the results.
DISTINCT can be used with aggregates: COUNT, AVG, MAX, etc.
DISTINCT operates on a single column. DISTINCT for multiple columns is not supported.