To select distinct columns you can mention them in the SQL query and to se

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

Question Posted / monal

Answer Posted / monal

To select distinct columns you can mention them in the SQL
query and to select all columns you can use select * from
information_schema.columns

Is This Answer Correct ?

2 Yes

8 No

Please Help Members By Posting Answers For Below Questions

Why variables called the most powerful component of ssis?

1025

What is sql view?

954

How can you check the level of fragmentation on a table?

986

what are questions asked in TCS for database tester (sqlserver)for 2-3 exp?

5872

What is the chart in report?

144

What does top operator do?

963

What does the on update no action do?

962

How to rename an existing column with the "sp_rename" stored procedure in ms sql server?

1032

What is extent? Types of extents?

1087

What are some examples of schemas?

909

What happens if we shrink log file in sql server?

910

Is foreign key unique?

957

Explain different types of lock modes in sql server 2000?

879

Are connections to sql server encrypted?

940

What is ms sql server index?

1024