select distinct * from tablename;

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

Question Posted / latha.s

Answer Posted / latha.s

Is This Answer Correct ?

6 Yes

1 No

Please Help Members By Posting Answers For Below Questions

What is the index requirement in SQL Azure?

How important do you consider cursors or while loops for a transactional database?

1010

What are clustered and non-clustered index?

1049

What is ms sql server reporting services?

1122

What are the basic functions for master, msdb, model, tempdb databases?

1095

What happens to a trigger with multiple affected rows?

994

What is RAID? What are the different types of RAID configurations?

1178

what are cursors? : Sql server database administration

1099

Why can there be only one clustered index and not more than one?

1040

What is default port number for sql server 2000?

1105

How do I find the query plan in sql server?

1015

Can we do dml on views?

1015

Is it ok to shrink transaction log?

1051

Does dbcc checkdb requires db to be in single_user mode? : sql server database administration

1028

What is t-sql script to take database offline – take database online.

1134