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
- 7361 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 resource governor in sql server?
How do you rebuild an identity column?
What is the impact on other user sessions when creating indexes?
What is BCP? When does it used in sql server 2012?
What is log shipping? Can we do logshipping with SQL Server 7.0 - Logshipping is a new feature of SQL Server 2000. We should have two SQL Server - Enterprise Editions. From Enterprise Manager we can configure the logshipping. In logshipping the transactional log file from one server is automatically updated into the backup database on the other server. If one server fails, the other server will have the same db and we can use this as the DR (disaster recovery) plan.
What stored by the model? : sql server database administration
How to set database to be read_only in ms sql server?
How do you test your database? : sql server database administration
What do you mean by sql server agent?
How to perform key word search in tables?
What are the benefits of normalization?
Do you know what is user defined datatypes and when you should go for them?
How many types of cursor type are there?
What is an indexed view?
What is the purpose of forms?
