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

what's the difference between a primary key and a unique key? : Sql server database administration

991


in the physical file layout, where should the transaction log be stored in relation to the data file?

1043


Why are sql functions used?

1184


What are the system database in sql server 2005?

1097


How will you hide an attribute? : sql server analysis services, ssas

1012


What is the Disadvantage of indexed sequential file.

1130


What is the main difference between ‘between’ and ‘in’ condition operators?

1276


What are partitioned views?

1052


How do you clear a log file?

1110


Where are stored procedures in sql server?

1127


What are cascading parameters in ssrs reports?

236


Write a query for primary key constraint with identity key word?

1082


Write an sql query for deleting duplicate rows?

1038


What is row_number () and partition by in sql server?

1136


What is the difference between for trigger and after trigger?

1161