please give me query code of unique fuction
select UNIQUE (name) from emp_info
Incorrect syntax near the keyword 'UNIQUE'.
Answer Posted / sakthi
select DISTINCT (Column_Name) from Table_Name
| Is This Answer Correct ? | 18 Yes | 2 No |
Post New Answer View All Answers
Does an index slow down updates on indexed columns?
Do you know what is difference between stored procedure and user defined function?
What is resource governor in sql server?
How can you insert null values in a column while inserting the data?
Why do we use stored procedures in sql server?
What is dimension table? : sql server analysis services, ssas
How to make a column nullable?
Do you know how to store and query spatial data?
Does a full backup include transaction log?
What is sql profiler. What are the default templates with it? : sql server database administration
What is the return type of executeupdate ()?
What is the command dbcc checkdb used for?
Explain how long are locks retained within the repeatable_read and serializable isolation levels, during a read operation with row-level locking?
what number files will a information contain in SQL Server? How many forms of information files exist in SQL Server? How many of those files can exist for a single database?
What is PROJECTION Operation?