over 4 years ago
It is used to fetch different values from a table. It removes duplicate records from the result set and used when there can be multiple duplicate tuples in a table.
SELECT DISTINCT columnname FROM tablename;
The below query will fetch different name and salary from Employee table as it will not return duplicate names.
SELECT DISTINCT(name),salary FROM Employee;
As we can see from the above example no duplicate names are fetched from the table just because of DISTINCT keyword used with name column.
Starting with Chrome version 45, NPAPI is no longer supported for Google Chrome. For more information, see Chrome and NPAPI (blog.chromium.org).
Firefox and Microsoft Internet Explorer are recommended browsers for websites using java applets.
Chrome Version Support
Are you sure, you want to delete this comment?
Terms of Service
| © copyright 2020 FindNerd.com. All rights reserved.
Sign up using