SQL Distinct

Advertisements

Select Command in SQL Select Unique in SQL

SQL Distinct

Select Distinct statement is used to retrieve only distinct or unique data. Select Distinct command is used with Select keyword.

Note: SQL Select Unique and SQL Select Distinct statements both are same.

Syntax

	
SELECT DISTINCT column_name, column_name
FROM table_name;

Employee table

emp_idnamesalary
101Amit24000
102Rahul34000
103Hitesh24000
104Gaurav26000
105Hitesh35000

Example

SELECT DISTINCT name
FROM Employee;

Result after Execute above query.

name
Amit
Rahul
Gaurav
Hitesh

Select Command in SQL Select Unique in SQL

Advertisements

Buy This Ad Space @$20 per Month, Ad Size 600X200 Contact on: hitesh.xc@gmail.com or 9999595223

Pure VPN Privide Lowest Price VPN Just @ $1.65. Per Month with Non Detected IP Lowest Price Non Detected IP VPN

Magenet is best Adsense Alternative here we earn $2 for single link, Here we get links ads. Magenet

For Projects 9999595223

Google Advertisements


Buy Websites 9999595223

Buy College Projects with Documentation Contact on whatsapp 9999595223. Contact on: hitesh.xc@gmail.com or 9999595223 Try this Keyword C++ Programs

Advertisements