Answer / amit

select distinct * from table_name

Answer / latha.s

select distinct * from tablename;

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

Answer / saleem

select *from tablename gives all distinct columns in the
table

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

What is the use of SCOPE_IDENTITY() function?

2 Answers  

What is MSDE?

2 Answers  

Can we join two tables without primary key?

0 Answers  

Some queries related to SQL

0 Answers   Motorola,

What are defaults? Is there a column to which a default can't be bound?

2 Answers   TCS,

Define compound operators?

0 Answers  

Your sql server is running out of disk space. You notice that there are several large files with ldf extensions what are these files?

0 Answers  

What are the advantages dts has over bcp?

0 Answers  

SYNTAX FOR VIEWS WITH EXAMPLE HOW TO LINK TWO TABLES

1 Answers   Microsoft,

List the various tools available for performance tuning?

0 Answers  

Do you know the cursor types?

0 Answers  

What are the types of constraints?

1 Answers