How to select Distinct columns from the table, table having 20 columns and i w

Categories >> Software >> Databases >> SQL Server
Suggest New Category

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

Question Posted / bhaskar

5 Answers
9969 Views
Wipro, I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

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

Answer / amit

select distinct * from table_name

Is This Answer Correct ?

18 Yes

7 No

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

Answer / latha.s

select distinct * from tablename;

Is This Answer Correct ?

6 Yes

1 No

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

Answer / ram

select * from tablename
select distinct * from tablename
above two select statements give same output with all
column name and also data
if we want only column name & its details(datatype,sizre)
use

select * from
information_schema.columns where table_name='EMP1'
(or)
select distinct * from
information_schema.columns where table_name='EMP1'

(Here Table name mustbe in single quotes and also capital
letters only)
here also both select statements output is same

Is This Answer Correct ?

0 Yes

0 No

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

Answer / saleem

select *from tablename gives all distinct columns in the
table

Is This Answer Correct ?

1 Yes

2 No

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

Answer / 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

Post New Answer