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

Explain what is scheduled job and how to create it?

Can a trigger be created on a view?

What is a view and what are its advantages?

how do we insert 100 records at a time in a table without using for loop in database

What is Cross Join and in which scenario do we use Cross Join?

How to find out the list schema name and table name for the database?

What will be the maximum number of index per table?

What is data source document?

What is meant by indexing files?

What is Peer to peer Replication?

What is the benefit of normalization?

explain what are the steps you will take, if you are tasked with securing an sql server? : Sql server database administration

For more SQL Server Interview Questions Click Here