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 a trigger?

Beginning with sql server version 7 0, a new enhanced data type nchar was added what type of data is supported with this data type?

How would you Update the rows which are divisible by 10, given a set of numbers in column?

What is the difference between TRUNCATE and DROP?

What do you understand by the denormalisation?

What is the STUFF function and how does it differ from the REPLACE function?

PC(code, model, speed, ram, hd, cd, price) Find the hard drive sizes that are equal among two or more PCs.

Display a roll having miminum marks in two subjects?

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

Which tcp/ip port does the sql server run on? How can it be changed?

What is difference between join and natural join?

What happens if you delete a table that is used by a view?

For more SQL Server Interview Questions Click Here