please give me query code of unique fuction

select UNIQUE (name) from emp_info

Incorrect syntax near the keyword 'UNIQUE'.



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

Post New Answer

More SQL Server Interview Questions

How do I manually uninstall an instance of sql server 2016?

0 Answers  


What is set nocount on and what is set nocount off?

0 Answers  


you have couple of stored procedures that depend on a table you dropped the table and recreated it what do you have to do to reestablish those stored procedure dependencies?

0 Answers  


What is mssql?

0 Answers  


How to choose all records from the table?

0 Answers  






What is the security principal at the server level that represents your session?

0 Answers  


How will u find the query which is running in some other machine

4 Answers   CarrizalSoft Technologies, IBM,


what is an index? : Sql server database administration

0 Answers  


How do you debug a procedure in sql server?

0 Answers  


How except clause is differs from not in clause?

0 Answers  


What is cube dimension? : sql server analysis services, ssas

0 Answers  


How do I list the available tables in a database I'm querying?

4 Answers  


Categories