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

What are triggers in ms sql server?

What is the use of builtinadministrators group in sql server? : sql server security

What are the pros and cons of creating extended stored procedures?

What new changes are being made in SQL Server?

What is the difference between clustered and non-clustered indexes in ms sql server?

what is package and it uses and how can u call a package

Write a SQL query to delete a table?

Explain what is scheduled job and how to create it?

Define Joins?

As per your opinion what are the five top responsibilities of a dba? : sql server database administration

What's the purpose of Stored Procedure?

What is the difference between ROW_NUMBER and Ranking function in SQL SERVER?

For more SQL Server Interview Questions Click Here