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 create a store procedure with encryption?

714

Tell me what is a linked server?

774

can a database be shrunk with users active? : Sql server administration

770

How do users use Report Builder with SQL Server data sources?

129

Explain what are the restrictions that views have to follow? : SQL Server Architecture

809

What are the different types of triggers in SQL SERVER?

728

How we can refresh the view?

800

What is use of attribute hierarchy ordered ? : sql server analysis services, ssas

748

When you should use a low fill factor?

727

How to maintain a fill factor in existing indexes?

713

What is cursors?

814

How to use transact-sql statements to access the database engine?

756

How to modify the underlying query of an existing view?

755

What is the function of sql server agent windows service?

759

Is sql server free?

680