Syntax:
SELECT DISTINCT column1, column2,.....columnN
FROM table_name
WHERE [condition]
Consider a Student record:
Roll No | Name | Age | Country | Course |
---|---|---|---|---|
101 | John | 18 | America | MBA |
102 | Sam | 16 | America | Aerospace |
103 | Sherry | 18 | Japan | MBBS |
104 | Harold | 23 | Korea | MTech |
SELECT DISTINCT Country FROM Students;
The above query will return the Distinct country names.
Output:
Country |
America |
Japan |
Korea |
Note: there’s a single America because we used the DISTINCT keyword.
Note: also read about SQL: HAVING Clause
Please follow me to read my latest post on programming and technology if you like my post.
https://www.instagram.com/coderz.py/
https://www.facebook.com/coderz.py
Staying up to the mark is what defines me. Hi all! I’m Rabecca Fatima a keen learner, great enthusiast, ready to take new challenges as stepping stones towards flying colors.
Given an integer A. Compute and return the square root of A. If A is…
Given a zero-based permutation nums (0-indexed), build an array ans of the same length where…
A heap is a specialized tree-based data structure that satisfies the heap property. It is…
What is the Lowest Common Ancestor? In a tree, the lowest common ancestor (LCA) of…
A Binary Search Tree (BST) is a type of binary tree that satisfies the following…