Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

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


Please Help Members By Posting Answers For Below Questions

How to update a field in SQL after ALTERING a row?

1232


Can we store videos inside the sql server table?

980


Why functions are used in sql server?

960


What methods do you follow to protect from sql injection attack?

1030


How to add more data to the testing table in ms sql server?

1089


can an order by clause be used in a creation of a view?

1183


Explain what is the purpose of sql profiler in sql server?

1076


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

967


Explain the flow of creating a cube? : sql server analysis services, ssas

1050


How to convert a unicode strings to non-unicode strings?

1102


What are the purposes and advantages stored procedure?

959


What is a covered index?

939


How to update values in a table with update statements in ms sql server?

1013


What are the advantages of partitioning?

1128


Explain the various types of concurrency problem. I.e. Lost or buried updates, uncommitted dependency, inconsistent analysis, phantom read?

951