Interested to Buy Any Domain ? << Click Here >> for more details...
how can u select the Distinct values in the table, table
having 20 columns , i want all columns
- 2 Answers
- 7402 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
Can anyone tell that the extra features are there in SQL SERVER 2008 that are not available in previous versions .
How can you check the level of fragmentation on a table?
You have modified 100 store procedures and want to replicate these changes from development to prodution, and production can have users using the Server/DB, how would you replicate without causing issues?
What are the extra roles available in msdb? : sql server security
What is simple indexing method?
How do I setup a local sql server database?
How does the report manager work in SSRS?
Is it true, that there is no difference between a rule and a check constraint?
Can you force a query to use a specific index?
What are the advantages of sql azure?
How can we get count of the number of records in a table?
what’s the difference between Covering Indexes and Clustered Indexes ? how to use clustered index small ?
What is database dimension? : sql server analysis services, ssas
Explain the properties of sub-query in sql server?
Explain about builtinadministrator?
