Blog

SQL Distinct

SQL

SQL Distinct

Here in the Employee table, the column country consists of more than one similar country names.

select_sql

We will now use the below query to get the distinct countries as follows

				
					SELECT DISTINCT Country FROM EMPLOYEE
				
			

Now we will get the distinct countries as in the image, with country names FR and UK.

Please comment and share if you like this post and tell us about how we can enhance our posts. Thanks.

Subhajit