How to select Distinct columns from the table, table having
20 columns and i want all coulmns
Answers were Sorted based on User's Feedback
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 |
Answer / saleem
select *from tablename gives all distinct columns in the
table
Is This Answer Correct ? | 1 Yes | 2 No |
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 |
can you any body tell me the difference between candidate key and primary key
syntax and example for bitmap index in sql???
What are indexes in ms sql server?
Explain log shipping and mention its advantages.
what is a deadlock? : Sql server database administration
In one interview...interviewer ask me question pleas tell me sql server architecture.. can any body tell me the sql server architecture with digram
what is IDE,DMV in sql server?
What are user defined functions in ms sql server?
how to write test cases for testing databases,especially for testing and writing test cases for stored procedures.any real time database testers.please answer me.
What does null mean?
Explain the relational database management system (rdbms)?
What are the common performance issues in sql server?