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 do you rename a table in sql server?
What is extent? Types of extents?
What do you understand by physical_only option in dbcc checkdb?
What is normalization and its types?
Which sql server is best?
Difference between report and query parameter.
What is dbcc? Give few examples.
How can sql server instances be hidden?
What are magic tables in sql server?
What is public role in sql server?
What is change data capture (cdc) feature?
What is tabulation?
Differentiate between mongodb vs. Sql server?
What happens if time-only values are provided as date and time literals?
Explain indexed views?