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
How to update a field in SQL after ALTERING a row?
Can we store videos inside the sql server table?
Why functions are used in sql server?
What methods do you follow to protect from sql injection attack?
How to add more data to the testing table in ms sql server?
can an order by clause be used in a creation of a view?
Explain what is the purpose of sql profiler in sql server?
but what if you have to create a database with two filegroups, one on drive c and the other on drive d with log on drive e with an initial size of 600 mb and with a growth factor of 15%? : Sql server database administration
Explain the flow of creating a cube? : sql server analysis services, ssas
How to convert a unicode strings to non-unicode strings?
What are the purposes and advantages stored procedure?
What is a covered index?
How to update values in a table with update statements in ms sql server?
What are the advantages of partitioning?
Explain the various types of concurrency problem. I.e. Lost or buried updates, uncommitted dependency, inconsistent analysis, phantom read?