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

What is mssql?

0 Answers  


when u import an excel file into sql if suppose one column has got a date field with system time attached to it what data type u will use in sql to import it in a table? Note: a condition is the excel file has no primary key defined to a column...also u r importing bulk data into sql

1 Answers  


Please differentiate between a local and a global temporary table?

0 Answers  


What's the information that can be stored inside a bit column?

0 Answers  


What is resource db in sql server?

0 Answers  






What is compression - row-level and page-level compression?

0 Answers  


How to provide Security for package?

1 Answers   Convergys,


What is scd (slowly changing dimension)? : sql server analysis services, ssas

0 Answers  


Is SET a SQL Keyword?

4 Answers   BitWise,


What are the all different types of Joins in SQL Server 2000, Anybody can explain each join with definition..Thanks in advance....

9 Answers   DELL, i Tech, Infosys, Siemens, TCS,


What are the advantages of using views. Why do we need views when we have SPs?

4 Answers   247Customer,


What is onf in normalization form?

0 Answers  


Categories