|
SELECT DISTINCT Country FROM Customers;
|
using distinct, if that column have repeated values, it display
only one of repeated values
|
|
SELECT COUNT(DISTINCT Country) FROM Customers;
|
it will give how many rows
|
|
select where clause
|
|
No comments:
Post a Comment