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 Cross Join

3 Answers  

What is difference between drop truncate and delete?

0 Answers  

what is the difference between a primary key and a unique key? : Sql server database administration

0 Answers  

What is the minimum and maximum number of partitions required for a measure group? : sql server analysis services, ssas

0 Answers  

What are cursors? Explain the different types of cursors Enlist a few disadvantages of cursors.

0 Answers   Genpact,

Explain the architecture of ms sql reporting service?

0 Answers  

What is the usage of the sign function?

0 Answers  

While using a cursor, how can you differentiate between a deleted row and a row that has been inserted with null data values?

0 Answers  

create index myindex on mytable(mycolumn) what type of index will get created after executing the above statement? : Sql server database administration

0 Answers  

Why truncate is ddl command?

0 Answers  

i need some interview questions on sql server developer plz any onee send some links.

2 Answers  

what is call by value & call by reference ?

2 Answers   Cap Gemini,