select distinct * from table

How to select Distinct columns from the table, table having
20 columns and i want all coulmns

Question Posted / amit

Answer Posted / amit

select distinct * from table_name

Is This Answer Correct ?

18 Yes

7 No

Please Help Members By Posting Answers For Below Questions

How to return the second 5 rows in ms sql server?

1018

What are the different types of upgrades that can be performed in sql server?

1134

You want to use a perspective in an mdx query. How do you select the perspective?

235

Can a table have 2 foreign keys?

862

How to apply filtering criteria at group level with the having clause in ms sql server?

961

What are the properties of the transaction?

975

Is t sql the same as sql server?

930

How to replace given values with null using nullif()?

938

What is recursion? Is it possible for a stored procedure to call itself or recursive stored procedure? How many levels of sp nesting is possible?

916

How to integrate the ssrs reports in application?

949

How to loop through result set objects using mssql_fetch_array()?

1035

How to run sql server 2005 books online on your local system?

928

Which rendering formats are affected by the pagesize properties?

138

How to rebuild master databse?

1040

What are the requirements for sql server 2016?

857