How to select Distinct columns from the table, table having
20 columns and i want all coulmns

Answer Posted / 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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Explain what is sql server english query?

731


What are the database roles? : sql server security

735


What is conditional split?

723


What is dirty page?

735


What do you mean by an execution plan? Why is it used?

740


What are the indexes in sql server?

715


What is a trace frag?

827


How to end a stored procedure properly in ms sql server?

758


what are the new features in SSRS?

115


What is SQL Server?

855


How to read data in a table with "select" statements?

739


What are horizontal and vertical scaling?

166


How do I find the sql server version?

715


What is default port number for sql server 2000?

762


What is spatial and temporal data?

715