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 |
What are some examples of schemas?
What is cdc in sql server?
Differentiate between sql temp table vs table variable?
What do you understand by replication in sql server? Mention the different types of replication in sql server.
Tell me what is sql profiler?
What are the lambda triggers?
Explain the architecture of ms sql reporting service?
To automatically record the time on which the data was modified in a table, which data type should you choose for the column?
What is sparse columns of sql server 2008?
As a part of your job, what are the DBCC commands that you commonly use for database maintenance?
What is the role that is required for killing a process What is the role that is required for creating a linked server
1 Answers CarrizalSoft Technologies, IBM,
What is molap and its advantage? : sql server analysis services, ssas