1. Categories >> Software >> Databases >> SQL Server
  2. Suggest New Category

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

Post New Answer

More SQL Server Interview Questions

System requirements for sql server 2005 express edition?

0 Answers  

What's the difference between a primary key and a unique key?

10 Answers   Wipro,

What is the SQL?????????????????????????????

5 Answers   CMS,

Define right outer join in sql server joins?

0 Answers  

What is the sql case statement used for?

0 Answers  




Define self join in sql server joins?

0 Answers  

Can we insert data if clustered index is disabled?

0 Answers  

What is the user of Primary key?

0 Answers  

What is built-in function?

0 Answers  

What is an indexing technique?

0 Answers  

What are various aggregate functions that are available?

0 Answers  

How to Handle the exceptions in Sqlsrver 2005??

3 Answers   Value Labs, Wipro,

For more SQL Server Interview Questions Click Here
Categories