please give me query code of unique fuction select UNIQUE (name) from emp

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

More SQL Server Interview Questions

What are the dmvs? : sql server database administration

What do we have to check in database testing?

How to rename an existing table with the "sp_rename" stored procedure in ms sql server?

How do I start sql server 2017?

Can a database be shrunk with users active?

wat will be the sql query to extract only last 3 records from table supose table hving thousands for records

how many joins we can write if at all we have n no of tables

What do you mean by the term 'normalization'?

Explain where clause?

How to use subqueries with the exists operators in ms sql server?

Write an sql query to find first weekday of the month?

Can multiple columns be used in sql group by clause in ms sql server?

For more SQL Server Interview Questions Click Here