select DISTINCT (Column_Name) from Table

please give me query code of unique fuction

select UNIQUE (name) from emp_info

Incorrect syntax near the keyword 'UNIQUE'.

Question Posted / sakthi

Answer Posted / sakthi

select DISTINCT (Column_Name) from Table_Name

Is This Answer Correct ?

18 Yes

2 No

Please Help Members By Posting Answers For Below Questions

How to select some specific columns from a table in a query in ms sql server?

943

What is code near application topology?

271

What are Spatial data types in SQL Server 2008

963

Differentiate between delete and truncate.

994

Does partitioning help performance?

887

Explain use of expression builder.

949

What are the database roles? : sql server security

1075

What is wide table?

885

What are the export options of ssrs?

165

What is difference between delete & truncate commands?

1023

Is it possible to update the views? If yes, how, if not, why?

969

What is the recovery model?

931

Explain syntax for dropping triggers?

885

If you are given access to a SQL Server, how do you find if the SQL Instance is a named instance or a default instance?

1040

What are subquery and its properties?

979