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 difference between cube operator and rollup operator? : SQL Server Architecture

0 Answers  

you are provided with the single table having say 4 col ie fname lname age city , now the all records with displying of only fname and lname is required but in this format say my name is abhay khanna it will come like this abhay-khanna rahul-roy gaurav-singh the above format is required

3 Answers  

Types of Authentications in Sql Server? How user gets authenticated through windows authentication?

0 Answers   MCN Solutions,

How to retrieve error messages using odbc_errormsg()?

0 Answers  

Suppose you want to implement the many-to-many relationships while designing tables. How would you do it?

0 Answers  

Explain what are the restrictions while creating batches in sql server?

0 Answers  

how can you move the master database

1 Answers   IBM,

two tables with table name ship(name,year) and battle (name,year),how to find the latest added year in the table ship

1 Answers  

What does executeupdate return?

0 Answers  

What is the difference between update lock and exclusive lock?

0 Answers  

What is importing utility?

0 Answers  

what is macro?

5 Answers   Excel, Global Innovation, Wipro,