please give me query code of unique fuction select UNIQUE (name) from emp

please give me query code of unique fuction

select UNIQUE (name) from emp_info

Incorrect syntax near the keyword 'UNIQUE'.

Question Posted / vimal katiyar

please give me query code of unique fuction select UNIQUE (name) from emp_info Incorrect synt..

Answer / sakthi

select DISTINCT (Column_Name) from Table_Name

Is This Answer Correct ?

18 Yes

2 No

More SQL Server Interview Questions

can you any body tell me the how to decrease the logfile

How to enforce security in sql server? : sql server security

How do I find query history in sql server?

How many types of stored procedures are there in sql server?

Define normalisation?

What is SQL Profiler and the use of it?

How can you tell if a database object is invalid?

Is there any performance difference between if exists (select null from table) and if exists (select 1 from table)?

What is the difference between a stored procedure and a user defined function in sql server?

How to list all triggers in the database with sys.triggers in ms sql server?

How to find related tables in sql server?

What is the difference between a Local temporary table and a Global temporary table? How is each one used?

For more SQL Server Interview Questions Click Here