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
What are “unrepeatable reads”?
what is denormalization? : Sql server database administration
What is function of CUBE ?
What is a trigger in sql server?
What kind of problems occurs if we do not implement proper locking strategy?
What is a domain constraint give an example?
What are the differences between user defined functions and stored procedures?
What is statement level trigger?
Define model database?
Explain the steps to create and execute a user-defined function in the sql server?
you want to be sure that queries in a database always execute at the maximum possible speed. To achieve this goal you have created various indexes on tables which other statement will keep the database in good condition? : Sql server administration
What is row_number () and partition by in sql server?
What is data mart? : sql server analysis services, ssas
What is a View ? Can we insert, Update and delete a view?
What is the default port for SQL Server over a firewall?