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 to select Distinct columns from the table, table having
20 columns and i want all coulmns

Answer Posted / amit

select distinct * from table_name

Is This Answer Correct ?    18 Yes 7 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What stored by the model? : sql server database administration

950


Explain various data region available in ssrs with their use?

932


What is xml datatype?

1074


What is the difference between primary key and unique constraints?

959


you have couple of stored procedures that depend on a table you dropped the table and recreated it what do you have to do to reestablish those stored procedure dependencies?

1044


if you encounter this kind of an error message, what you need to look into to solve this problem? : Sql server database administration

984


What is implicit mode in sql server?

1103


What are audit control procedures?

989


What are different types of subquery?

1243


What is the meaning of resultset type_scroll_insensitive?

953


How many files can a database contain in sql server?how many types of data files exists in sql server? How many of those files can exist for a single database?

1139


What is difference between cte and view?

914


What are types of storage modes? : sql server analysis services, ssas

1035


What is difference between clustered index and non clustered index?

1074


How to provide login information for a new odbc dsn?

1051