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

How would you add a section to a table?

1012

Find columns used in stored procedure?

969

What is indexed view? How to create it?

969

What are cursors stored procedures and triggers?

988

What is 'write-ahead log' in sql server 2000 ?

1031

Will count(column) include columns with null values in its count?

1075

what is memory-optimized nonclustered indexes

1002

What is resource db in sql server?

1000

Recommend an approach to ensuring that all changes in the remote databases synchronize with the SQL Azure database?

128

What is snapshot replication?

1037

Why we use functions in sql server?

1054

Explain how you can configure a running aggregate in SSRS?

163

What triggers long term care?

1011

Why we use trigger in sql server with example?

945

What happens if ntwdblib.dll is missing on your machine?

1129