SQL – Distinct

Spread the love

Distinct – it fetches the unique values from table basis on column’s selection in the statement.

Syntax –

Sql server

Select distinct column_name1 from table_name

Oracle Database

Select unique column_name1 from table_name

Select * from BrandName

S.NOPRODUCTMONTHYEAR
1NIKEDEC2016
2REEBOKJAN2014
3FILAFEB2017
4PUMAJAN2015
5REEBOKFEB2016
6FILAMAR2015

Select DISTINCT Product from BrandName

PRODUCT
1NIKE
2REEBOK
3FILA
4PUMA

 

 

sql distinct values search keyword
distinct values search keyword
find distinct values in sql search keyword
sql find distinct value from table search keyword
find distinct value by sql query search keyword
sql distinctions values search keyword
get distinct values sql search keyword
select distinct value by sql query search keyword
sql query find distinct value from table search keyword