how can u select the Distinct values in the table, table
having 20 columns , i want all columns
Answer Posted / krishnamoorthy.n
select distinct * from <tablename>
| Is This Answer Correct ? | 4 Yes | 3 No |
Post New Answer View All Answers
How to rebuild all indexes on a single table?
Which operator do you use to return all of the rows from one query except rows are returned in a second query?
How to download microsoft sql server 2005 express edition?
Write a sql query to delete duplicate records from a table called table1
Which rendering formats are affected by the pagesize properties?
what’s the difference between Covering Indexes and Clustered Indexes ? how to use clustered index small ?
What is the new security features added in sql server 2014? : sql server security
What is the difference between cube operator and rollup operator? : SQL Server Architecture
In what version of sql server were synonyms released?
What the different components of Replication and what is their use?
What is the downside of using udf?
What is dirty read?
How to find the version of sql server? : sql server database administration
Explain the properties of subqueries in sql server?
What is tempdb in sql server?