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

can you instantiate a com object by using t-sql? : Sql server database administration

961

What is the difference between implicit and explicit transaction?

961

Explain about Views?

1007

What objects does the fn_my_permissions function reports on? : sql server security

991

In which files does sql server actually store data?

851

Can a stored procedure call itself or recursive stored procedure? How much level sp nesting is possible?

959

What are the main sources of data?

1036

What do you mean by an execution plan? How would you view it?

868

When you should use a low fill factor?

942

What is de-normalization and what are some of the examples of it?

923

How to connect Azure federated root database and apply federation in entity framework?

107

If you want to send some data from access database to sql server database. What are different component of ssis will you use?

918

Differentiate between a local and a global temporary table?

898

Explain about integration services of Microsoft SQL server?

982

What are the joins in sql server? : sql server database administration

962