how can u select the Distinct values in the table, table
having 20 columns , i want all columns
- 2 Answers
- 6883 Views
- I also Faced
- E-Mail Answers
Answer Posted / krishnamoorthy.n
select distinct * from <tablename>
| Is This Answer Correct ? | 4 Yes | 3 No |
Post New Answer View All Answers
What is the process of normalising?
What is clustered vs nonclustered index?
What is an expression in ms sql server?
What are the essential components of sql server service broker?
How to enter unicode character string literals in ms sql server?
Does sql server 2000 full-text search support clustering?
What are the functions in sql server?
what is an extended stored procedure? Can you instantiate a com object by using t-sql? : Sql server database administration
Where does the copy job runs in the log shipping primary or secondary? : sql server database administration
What is change tracking in sql server?
What is the difference RDBMS and Graph Database?
How to use clusters?
explain different types of constraints? : Sql server database administration
1.what are diff types of joins , and explain diff between cross join and full outer join 2.diff types of views 3. Diff types of index 4. What is diff b/w stores procedure and function procedure 5.diff between double and int in SQL 6.diff between char and varchar in SQL. 7.Oracle or SQL whice you will preferred and why.
What is the default order of an order by clause?
