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 is bit data type? What's the information that can be stored inside a bit column?

How can i change the column name.

what is the difference between group and having give an example with query and sample output

Other than truncate statement, which other command can by-pass the trigger on the tables?

Which sql server table is used to hold the stored procedure scripts?

What is purpose of normalization?

Why and when do stored procedure recompile?

WRITE A FUNCTION TO DISPLAY THE OUTPUT OF AN EXISTING TABLE RANGE LIKE COMMAM SEPERATED VALUES LIKE RANGE1,RANGE2,...

Does partitioning help performance?

What is inner join in sql server joins?

What is ms sql server index?

i need some interview questions on sql server developer plz any onee send some links.

For more SQL Server Interview Questions Click Here