select *from tablename gives all distinct columns in the table

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

Question Posted / saleem

Answer Posted / saleem

select *from tablename gives all distinct columns in the
table

Is This Answer Correct ?

1 Yes

2 No

Please Help Members By Posting Answers For Below Questions

Does a specific recovery model need to be used for a replicated database? : sql server replication

912

Can you explain what is the use of custom fields in report?

1000

How to write a query with an inner join in ms sql server?

997

What is the significance of null value and why should we avoid permitting null values?

915

Due to some maintenance being done, the sql server on a failover cluster needs to be brought down. How do you bring the sql server down?

1265

How is table type constraint applied to a table?

933

What are functions in the sql server?

1127

What are the steps to take to improve performance of a poor performing query? : sql server database administration

978

When is the use of update_statistics command?

950

Write a sql query to sort on different column name according to the parameters passed in the function?

852

What is clustered index

951

Do you know how to send email from database?

927

How do I shrink an ldf file?

932

What is the native system stored procedure to execute a command against all databases?

968

Can we take the full database backup in log shipping?

899