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...

how can u select the Distinct values in the table, table
having 20 columns , i want all columns

Answer Posted / krishnamoorthy.n

select distinct * from <tablename>

Is This Answer Correct ?    4 Yes 3 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How to rebuild all indexes on a single table?

1050


Which operator do you use to return all of the rows from one query except rows are returned in a second query?

984


How to download microsoft sql server 2005 express edition?

1036


Write a sql query to delete duplicate records from a table called table1

1023


Which rendering formats are affected by the pagesize properties?

144


what’s the difference between Covering Indexes and Clustered Indexes ? how to use clustered index small ?

1959


What is the new security features added in sql server 2014? : sql server security

992


What is the difference between cube operator and rollup operator? : SQL Server Architecture

1116


In what version of sql server were synonyms released?

936


What the different components of Replication and what is their use?

1059


What is the downside of using udf?

1099


What is dirty read?

1076


How to find the version of sql server? : sql server database administration

1102


Explain the properties of subqueries in sql server?

1073


What is tempdb in sql server?

967